Selecting dynamic types using Linq to SQL

Question

I would like to select from a table using linq to sql without knowing what that table is until runtime, something like

Type t = Type.GetType(myString);
var results = from o in context.t select o;

Obviously this doesn't work, but I was wondering if there was a way to do this.

Jon Skeet · Accepted Answer · 2010-08-22 20:40:37Z

2

Well, you can use DataContext.GetTable(Type). That returns an ITable. Without knowing more about what you're trying to do, that's the closest we can really come to answering... if you can give more detail, we may be able to help you more.

answered Aug 22, 2010 at 20:40

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sonicblis Over a year ago

Yea, sorry for being an idiot. I hadn't referenced the System.data.linq assembly yet in my WCF project, so I was only getting table names as properties off my context instantiation and wasn't thinking clearly to realize my intellisense wasn't showing everything. Thanks for the response.

Collectives™ on Stack Overflow

Selecting dynamic types using Linq to SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related