Dynamic Table in LINQ to SQL query

Question

I have several references in DB with same table structure. I don't want to write several LINQ queries to each db. Is it possible to develop one query with dynamic Table parameter? My query example:

var query =
            from myTranslations in myContext.translations
            where myTranslations.code == strLabelCode
            select myTranslations;

If you've duplicated the same structure multiple times in your database... you've probably got a basic design problem. Why not refactor al those "Same Table Structures" into a single table structure & differentiate between the data they contain using a TypeId. — Eoin Campbell
– Eoin Campbell, Commented Jun 1, 2012 at 10:31
I can't do that because one reference can be for details and other for users. It's not good experience to sore them together. — Ars
– Ars, Commented Jun 1, 2012 at 10:44

TomTom · Accepted Answer · 2012-06-01 10:26:15Z

1

No, sorry. Simple like that - only via for example reflection, which makes it - ah - hard er than having multiple table objects.

answered Jun 1, 2012 at 10:26

TomTom

62.4k11 gold badges95 silver badges152 bronze badges

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

Comments

rt2800 · Accepted Answer · 2012-06-01 10:32:00Z

0

Use datacontext GetTable() method to vary table type as listed here MSDN

answered Jun 1, 2012 at 10:32

rt2800

3,0552 gold badges22 silver badges26 bronze badges

Collectives™ on Stack Overflow

Dynamic Table in LINQ to SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related