public static List <MyProduct> GetMyProductsByName(string namePart) { using (MyProductDataContext dc = new MyProductDataContext(new CatalogDataContext())) { List <MyProduct> myProduct = (from product in dc.myProducts where product.Name.Contains(namePart) select product).ToList(); return(myProduct); } }
public static List <MyProduct> GetMyProductsWithNRecentReviews(int howManyReviews) { using (MyProductDataContext dc = new MyProductDataContext(new CatalogDataContext())) { List <MyProduct> myProduct = (from product in dc.myProducts where product.ProductReviews.Count == howManyReviews select product).ToList(); return(myProduct); } }
public static List <MyProduct> GetNMyProductsFromCategory(string categoryName, int n) { using (MyProductDataContext dc = new MyProductDataContext(new CatalogDataContext())) { List <MyProduct> myProducts = (from product in dc.myProducts where product.ProductSubcategory != null && product.ProductSubcategory.ProductCategory.Name.Equals(categoryName) orderby product.ProductSubcategory.Name select product).Take(n).ToList(); return(myProducts); } }
public static List <MyProduct> GetProductsByName(string namePart) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { MyProductDataContext dataContext = new MyProductDataContext(dc); IEnumerable <MyProduct> query = from p in dataContext.MyProducts where p.Name.Contains(namePart) select p; return(query.ToList()); } }
public static List <MyProduct> GetProductsWithNRecentReviews(int howManyReviews) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { MyProductDataContext dataContext = new MyProductDataContext(dc); IEnumerable <MyProduct> query = from p in dataContext.MyProducts where p.ProductReviews.Count == howManyReviews select p; return(query.ToList()); } }
public static List <MyProduct> GetNProductsFromCategory(string categoryName, int n) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { MyProductDataContext dataContext = new MyProductDataContext(dc); IEnumerable <MyProduct> query = from p in dataContext.MyProducts where p.ProductSubcategory != null && p.ProductSubcategory.ProductCategory != null && p.ProductSubcategory.ProductCategory.Name == categoryName orderby p.Name select p; return(query.Take(n).ToList()); } }