public static void ShowProductsByCategory()
{
using (var db = new NorthwindDb())
{
var orders = db.Orders
.Where(o => o.Order_Details.All(od => od.Product.Category.CategoryID == 1))
.Select(o => new
{
o.Customer.CompanyName,
o.Order_Details,
Products = o.Order_Details.Select(od => od.Product)
});
foreach (var order in orders)
{
Console.WriteLine("Company Name: {0}", order.CompanyName);
Console.WriteLine("\t\tProducts:");
foreach (var product in order.Products)
{
Console.WriteLine("\t\t\tName: {0}, Category: {1}", product.ProductName, product.Category.CategoryName);
}
}
}
}
static void ChangeCategories()
{
using (var db = new NorthwindDb())
{
var regions = db.Regions;
foreach (var region in regions)
{
region.RegionDescription = "New value";
}
db.SaveChanges();
}
}
static void ShowRegions()
{
using (var db = new NorthwindDb())
{
foreach (var region in db.Regions)
{
Console.WriteLine("Region description: {0}", region.RegionDescription);
foreach (var territory in region.Territories)
{
Console.WriteLine("\t\tTerritory description: {0}", territory.TerritoryDescription);
}
}
}
}
private void loadButton_Click(object sender, EventArgs e)
{
textBox.Text = NorthwindDb.GetData();
}
private void loadButton_Click(object sender, EventArgs e)
{
var path = @"northwind.xml";
textBox.Text = NorthwindDb.GetData(path);
}
