Entity Framework Select table using a string

Question

Is it possible to select table with a string when using Entity Framwork generated code?

Example:

using (var db = new Model1())
{
    db.Database.Connection.ConnectionString = CreateConnectionString();
    var res = from a in db.R1
              select a;
    foreach (var item in res)
    {...}
}

But what I want is like

using (var db = new Model1())
{
    String tablename = "R1";
    db.Database.Connection.ConnectionString = CreateConnectionString();
    var res = from a in db.tablename
              select a;
    foreach (var item in res)
    {...}
}

I need to do a select on a number of tables named R1 to R12, they look almost the same.

I can solve it with a direct SQL query but I want to use Entity Framework as much as possible.

The post in Entity Framework inline SQL dynamically select table name is almost right, but I want to select all columns and preferbly get right type back.

Or am I going aboutit the wrong way? Should I use something else than EF?

Any help would be preciated!

you should use a generic method, then you can use db.Set<T>. And you have to use reflection to get a type from your string. — tschmit
– tschmit, Commented Mar 4, 2015 at 12:52
There exists a old (but nice) library for dynamic linq queries. Not sure if it will help you out in this case. You might want to combine it with the stackoverflow question. Links: weblogs.asp.net/scottgu/… stackoverflow.com/questions/5032228/… — Stefan
– Stefan, Commented Mar 4, 2015 at 12:53
There might be an update to that, or similar, project here, not sure though: github.com/kahanu/System.Linq.Dynamic — Stefan
– Stefan, Commented Mar 4, 2015 at 12:56

Mark Shevchenko · Accepted Answer · 2015-03-04 12:51:21Z

1

You can use SqlQuery:

var sql = string.Format("SELECT * FROM [{0}]", tablename);
var query = db.Database.SqlQuery<R1>(sql);

It could work if all of your tables R1--R2 have the same structure (properties and their types).

answered Mar 4, 2015 at 12:51

Mark Shevchenko

8,2651 gold badge28 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Select table using a string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related