public List<Products> GetAllProducts() { using (NorthwindEntities context = new NorthwindEntities()) { var query = from p in context.Products select p; return query.ToList(); } }
public Products GetProduct(int id) { Products prod = new Products(); using (NorthwindEntities context = new NorthwindEntities()) { prod = (from p in context.Products where p.ProductID == id select p).First(); return prod; } }