How can I create a LINQ-to-SQL statement when I have table name as string?

Question

If I have the name of a database table like this:

string tableName = "Addresses";
string tableName = "Customers";

How can I construct a dynamic LINQ statement like this:

var items = from o in db.{tableName}
            select o;

foreach (var item in items)
{
    sb.Append(item.Id + Environment.NewLine);
}

I know I could do something like this:

IEnumerable<Customer> results = db.ExecuteQuery<Customer>
    ("SELECT contactname FROM customers WHERE city = {0}",
    "London");

But in this instance I don't want strongly typed objects as my result, I just want a recordset to pick apart.

Answer:

Thanks Shalkalpesh, I took your advice and solved this by just avoiding LINQ altogether:

SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["main"].ToString();
conn.Open();
string sql = "SELECT * FROM " + tableName;
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dtResult = new DataTable();
da.Fill(dtResult);
foreach (DataRow drRow in dtResult.Rows)
{
    Console.WriteLine(drRow["Id"].ToString());
}
da.Dispose();
conn.Close();
conn.Dispose();

Answer 1

If you want the recordset, you can access the Connection property of the DataContext class (db variable in your context) and use it to execute regular query and get the result in either of DataTable or DataReader.