asp.net mvc linq to sql in scenario

Question

i want to implement the "in" in sql in linq to sql .how can i do that ?

Answer 1

Check out Creating IN Queries With Linq To Sql

Answer 2

something like this?...

namespace xxx.xxx.xxxx { public class xxxx { private Entities db = new Entities();

    // List All Products

    public IQueryable<Product> GetAllProducts()
    {
        return from product in db.Products
               select product;
    }