Use IN Keyword in Link Queue?

Question

How to use IN keyword in Linq Queue?
Like
select * from tablename
where columnname in (1,2,3,4)
but in Linq Queue, What is the syntax of using IN keyword? Thankyou

Sandeep Singh Shekhawat · Answer

private void GetEmployee()
{
int [] Ids = { 1, 2, 3, 4 };
EmployeeOperationDataContext employeeContext = new  EmployeeOperationDataContext ();
var employee = from emp in employeeContext.EMPLOYEEs
where Ids.Contains(emp.Id)
select emp;
gridEmployee.DataSource = employee;
gridEmployee.DataBind();
}
Above query will be generated as below in debug mode to execute on sql server:
SELECT [t0].[Id], [t0].[Name], [t0].[SALARY]
FROM [dbo].[EMPLOYEE] AS [t0]
WHERE [t0].[Id] IN (@p0, @p1, @p2, @p3)
Hope It would be helpful.
Thanks
Sandeep

Vulpes · Answer

Try something like:
var query = from row in tablename where new[]{1,2,3,4}.Contains(row.columnname) select row;

Answer

It is not supported directly. You need to use a collection and check your value is present in that collection.
AdventureWorks.DB db= new DB();
var itemQuery = from cartItems in db.SalesOrderDetails
where cartItems.SalesOrderID == 75144
select cartItems.ProductID;
var myProducts = from p in db.Products
where itemQuery . Contains (p.ProductID)
select p;
http://msdn.microsoft.com/en-us/vstudio/bb688084.aspx