How can I supply a table name at runtime using LINQ to SQL?

Question

I have to use LINQ to SQL and along with it a pure SQL classic query. And this SQL query has the Table from where my data will be generated, but I will not know this Table previously. It will be known in compile time.

So how can I make LINQ understand from what Table I want to make the query?

Answer 1

Good discussion here: Dynamic SQL table name