public static string GetProductAndVendorString(this List <Product> products) { BazaDanychDataContext dataContext = new BazaDanychDataContext(); string outString = ""; List <int> productIds = new List <int>(); foreach (var product in products) { productIds.Add(product.ProductID); } var productVendor = (from v in dataContext.Vendor join pv in dataContext.ProductVendor on v.BusinessEntityID equals pv.BusinessEntityID join p in dataContext.Product on pv.ProductID equals p.ProductID where productIds.Contains(p.ProductID) select new { productName = p.Name, vendorName = v.Name }).Distinct().ToList(); foreach (var it in productVendor) { outString += it.productName + "-" + it.vendorName + "\n"; } return(outString); }
public void TestInitialize() { var dc = new BazaDanychDataContext(); Tools.DataContext = dc; MyTools.DataContext = dc; myProducts = new List <MyProduct>(); // wypełnienie listy MyProduct foreach (var product in dc.Product.ToList()) { myProducts.Add(new MyProduct(product)); } }
static void Main(string[] args) { var dc = new BazaDanychDataContext(); Tools.DataContext = dc; MyTools.DataContext = dc; List <MyProduct> myProducts = new List <MyProduct>(); // wypełnienie listy MyProduct foreach (var product in dc.Product.ToList()) { myProducts.Add(new MyProduct(product)); } int number = 5; var myProducts1 = MyTools.GetNRecentlyReviewedProducts(myProducts, number); foreach (var itProduct in myProducts1) { Console.WriteLine(itProduct.Name); } }