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);
}
}
