Use table name as variable

Question

I'm trying to use table name as variables

Base on this question here

I'm able to do it in some cases but in this one:

var usersId = db[tableNameLabel].All().Select(db[tableNameLabel].userid,
db[tableNameLabel].rating.Count().As("Count"));

I get the next error:

"The best overloaded method match for 'Simple.Data.DataStrategy.this[string]' has some invalid arguments"

Update:

Fixed it.

var usersId = db[tableNameLabel.Text].All().Select(db[tableNameLabel.Text].userid,
db[tableNameLabel.Text].rating.Count().As("Count"));

Needed tableNameLabel.Text.

Thanks

You might want to tag your question(s) with C# as well. Also, for us that isn't fluent in simple.data, which object is of type `DataStrategy` in this question? — Lasse V. Karlsen, Jul 20 '14 at 20:06
I'm not fluent either. I just finish a simple app using this Simple.Data framework, but now I require to use dynamic tables. So I have problems with it. — antoniomtz, Jul 20 '14 at 20:10
The following query is supposed to return a SimpleQuery [link](http://simplefx.org/simpledata/docs/pages/Retrieve/Commands/All.html) . However, when using variables for the table name, for some reason it returns DataStrategy. Just in this query specific though. The rest of them are simpler and working well. — antoniomtz, Jul 20 '14 at 20:16
Thank you, you were right. Forgot tableNameLabel.text, you saved me alot of work — antoniomtz, Jul 20 '14 at 20:21

score 0 · Accepted Answer · answered Jul 20 '14 at 20:25

The only place in the code in the question where you use an indexer is in this expression:

db[tableNameLabel]

The error message:

he best overloaded method match for 'Simple.Data.DataStrategy.this[string]' has some invalid arguments

is noting an indexer, DataStrategy.this[string].

Clearly the compiler doesn't think that tableNameLabel is of type string, so check out that variable and see what it is.

Perhaps you meant to dereference a property off of that variable?

1 Answers1