CODEWITHSUNDEEP
c#.netentity-frameworkentity-framework-4ado.net-entity-data-model
Anthony Gatlin
Anthony Gatlin

Reputation: 4413

How can you dynamically select a table with entity framework 4.x?

Suppose I have a database named MyDatabase which has two tables - MyTable1 and MyTable2. Using the Code First approach with Entity Framework 4.x and .NET 4, I have generated a context named MyDatabaseContext which contains MyTable1s and MyTable2s.

Normally, tables are accessed like MyDatabaseContext.Table1s.<Command>. In my database many tables share a couple of common fields (e.g. CreatedOn, ModifiedOn). I would like to to be able to dynamically substitute a table name so I can execute the same query against any table.

What I really want (and which does not seem to be available) is something like MyDatabaseContext[ContextTableName].<Command>.

Does anyone have any idea if such functionality exists to dynamically select a table at query time.

Upvotes: 5

Views: 8146

Answers (2)

danvasiloiu
danvasiloiu

Reputation: 751

i had same issue with tables that were build for each day like: TableName_2014_06_06

In the end i just went back to basics and used SqlConnection .. I suggest that you do the same

Upvotes: 0

endyourif
endyourif

Reputation: 2202

Check out dynamic linq. Here is an article about it from Scott Guthrie: http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx

Upvotes: 2

Related Questions