LINQ To Entity

Linq to Entity is in the market for a while..

Recently I faced a problem on how to use SQL IN Clause in LINQ.

Suppose you want to execute a query like:

SELECT * FROM TABLE1 WHERE COLUMN1 in (Value1, Value2)

in order to form the In clause in LINQ, one need to create a List.

Here is the code to create a list:

Suppose you want to search users of two departments eg 1,2

            List<int> dept = new List<int>();
            dept.Add(1);
            dept.Add(2);

            var query = from lst in dc.UserMasters
                        where dept.Contains(lst.DeptId)
                        select lst;