Linq to Entities question RRS feed

  • Question

  • Hi, i have a very basic question about linq to entities and Entity Framework.

    If i do a query like this.


    products.Where(p=>p.IdCategory==1).Select(p=> new{name=p.Name,category=p.Category.Name});


    The Where and Select methods are transformed to SQL statements? o the query just retrieve all products to memory and the filtering is made in memory?






    Wednesday, June 23, 2010 11:41 PM