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