public static List <MyProduct> GetMyProductsByName(string namePart) { using (MyProductDataContext dataContext = new MyProductDataContext(new ProductionDataContext())) { List <MyProduct> result = (from product in dataContext.MyProducts where product.Name.Contains(namePart) select product).ToList(); return(result); } }
public static List <MyProduct> GetNMyProductsFromCategory(string categoryName, int n) { using (MyProductDataContext dataContext = new MyProductDataContext(new ProductionDataContext())) { List <MyProduct> result = (from product in dataContext.MyProducts where product.ProductSubcategory != null && product.ProductSubcategory.ProductCategory.Name.Equals(categoryName) orderby product.ProductSubcategory.Name select product).Take(n).ToList(); return(result); } }
public static string GetMyProductVendorByProductName(string productName) { using (ProductionDataContext dataContext = new ProductionDataContext()) { MyProductDataContext myDataContext = new MyProductDataContext(dataContext); string result = (from myProduct in myDataContext.MyProducts join vendor in dataContext.ProductVendor on myProduct.ProductID equals vendor.ProductID where myProduct.Name == productName select vendor.Vendor.Name).First(); return(result); } }