Linq To Sql - Dynamic

I have two Tables:

Table 1: Client

Fields: Id_Client Char 5 Name_Client Char 50

Table 2: Country

Fields: Id_Country Char 4 Name_Country Char 80 Population Int 15

With Sql I can make this 2 queries

Select Id_Client, Name_Client from Client

Select Id_Country, Name_Country, Population from Country

I wan to do this 2 queries in only one using Linq SQL. I think something like this

string Option = "";

string SelectFields = ""; string TableName = "";

if (Option == "Client"){

   SelectFields = "Id_Client, Name_Client";
   TableName = "Client"; 

} else{

   SelectFields = "Id_Country, Name_Country, Population";
   TableName = "Country";

}

开发者_JAVA技巧Select "SelectFields" from "TableName"

I'm a Visual Fox Pro Developer and using Evaluate (macros) this is very easy to do. Is possible to do something like this on Linq To Sql???

Sorry for my poor english

---

You will want to look into dynamic linq to sql, this will allow you to pass in the expression as a string.

In the end you will end up with something like the following:

IQueryable<SomeItem> = results = context.SomeItem.Where("SomeItemID > 30 AND SomeItemID < 40");

Additional Information, Using Dynamic Linq