Dynamic Table name into Linq Query

Question

Dear All I have a Query? How to Add Dynamic Table Name into Linq Query. I have serch lot but never get the Solution. Please provide the code as Thanks in Advanced

Sandip Patil · Answer

For Example i have multiple Table names Ex from u in z02db.z03_inv1_1 where u.LocalCol >= sdate && u.LocalCol orderby u.LocalCol ascending select new { u.LocalCol u.INV1_AC_POWER_KW } whithi this query the table name is 'z03_inv1_1' but i have another multiple table like z03_inv1_2 z03_AJB1 etc. now i would like to use same query using Dynamic Table Name how to use it?

Nilesh Shah · Answer

post whatever code you have written and clearly specify what solution you need