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;

Muralidharan Deenathayalan · 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

Use IN Keyword in Link Queue?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)