public static void productSelect() { var productSelect = new ProductsSC().GetProducts().Select(s => new { ProductId = s.ProductId, ProducName = s.ProductName, ProductUnits = s.UnitsInStock }).ToList(); }
//SELECT ProductID, ProductName, UnitPrice FROM Products //Where CategoryID = ID public static void Product(int ID) { var ProductQry = new ProductsSC().GetProduct().Select(s => new { s.ProductId, s.ProductName, s.UnitPrice, s.CategoryId }).Where(w => w.CategoryId == ID); var output = ProductQry.ToList(); }
public List <Product> Get() { var product = new ProductsSC().GetAllProducts().ToList(); return(product); }
public List <Product> Get() { var Products = new ProductsSC().GetProduct().ToList(); return(Products); }