c# - Get table-data from table-name in LINQ DataContext

Question

I need to get table data from table name from Linq DataContext.

Instead of this

var results = db.Authors;

I need to do something like this.

string tableName = "Authors";

var results = db[tableName];

It could be any table name that is available in DataContext.

Answer 1

Given DataContext context and string tableName, you can just say:

var table = (ITable)context.GetType()
                           .GetProperty(tableName)
                           .GetValue(context, null);