I have a vague feeeling i have seen this before, but my search terms have not found it...

Is it possible to create a collectoin using only the name of the (SQL Server) table?

IE: if I pass 'MASTER_TABLE_DATA' to this hypothetical method, how do I go about getting a MasterTableDataCollection returned?

stoneyowl wrote:

I have a vague feeeling i have seen this before, but my search terms have not found it...

Is it possible to create a collectoin using only the name of the (SQL Server) table?

IE: if I pass 'MASTER_TABLE_DATA' to this hypothetical method, how do I go about getting a MasterTableDataCollection returned?

You should work with entity names. You can then use the Activator class, which is a .NET class to instantiate objects by using a type name in a string.

So you pass in MasterTableData as name, and attach to that 'Collection'. You then create an instance of that collection with the Activator class and assign it to a variable of type IEntityCollection.

You then call GetMulti(null, ... ) on that variable. Et viola

About what I thought. I can do that. Is is possible (he asked hopefully) that there is a method in the LLBLGen code that will produce a 'standard' entity name from the passed in SQL table name, to which I can then add the 'Collection' or Entity' prefix?

Well, now I get this....

Cannot apply indexing with [] to an expression of type 'SD.LLBLGen.Pro.ORMSupportClasses.IEntityCollection'

when I try to interate over the returned collection....

Never mind - I solved it.