How can I use any table name for get any record from any table use Linq2db. I try use generic, but I don't understand how I have to set the current table.
public void ObjectGetById<T>(int id, ref T obj)
{
string tbl = obj.GetType().Name;
using (var db = new cwDB("city5"))
{
IQueryable<T> r = (from p in db.GetTable<>().TableName(tbl) select p);
r = from p in r where p.ID == id select p;
obj = (T)(object)r.FirstOrDefault();
}
}