private static void LazyLoading()
{
using (var context = new SampleContext())
{
// Log SQL to the console
context.Database.Log = Console.Write;
// Get category and related products
Console.WriteLine("Category Id:");
var categoryId = int.Parse(Console.ReadLine());
var category = context.Categories.Single(c => c.Id == categoryId);
foreach (var product1 in category.Products)
{
Console.WriteLine("{0} {1} {2} {3}",
product1.Id, product1.ProductName, product1.Price.ToString("C"),
product1.Category.CategoryName);
}
// Get product and related category
Console.WriteLine("Product Id:");
var productId = int.Parse(Console.ReadLine());
var product2 = context.Products.Single(p => p.Id == productId);
Console.WriteLine("{0} {1} {2} {3}",
product2.Id, product2.ProductName, product2.Price.ToString("C"),
product2.Category.CategoryName);
}
}
private static void SeedData()
{
using (var context = new SampleContext())
{
// Create categories
var beverages = context.Categories.Add(new Category { CategoryName = "Beverages" });
var condiments = context.Categories.Add(new Category { CategoryName = "Condiments" });
var confections = context.Categories.Add(new Category { CategoryName = "Confections" });
// Create beverages
context.Products.Add(new Product { ProductName = "Chai", Price = 10, Category = beverages });
context.Products.Add(new Product { ProductName = "Chang", Price = 20, Category = beverages });
context.Products.Add(new Product { ProductName = "Ipoh Coffee", Price = 30, Category = beverages });
// Create condiments
context.Products.Add(new Product { ProductName = "Aniseed Syrup", Price = 40, Category = condiments });
// Create confections
context.Products.Add(new Product { ProductName = "Chocolade", Price = 50, Category = confections });
context.Products.Add(new Product { ProductName = "Maxilaku", Price = 60, Category = confections });
// Persist changes
context.SaveChanges();
}
}
private static void QueryData()
{
using (var context = new SampleContext())
{
// Get categories
var categories = context.Categories.OrderBy(c => c.CategoryName);
foreach (var category in categories)
{
Console.WriteLine("{0} {1}", category.Id, category.CategoryName);
}
// Get products by category
Console.WriteLine("\nCategory Id:");
var categoryId = int.Parse(Console.ReadLine());
var products = from p in context.Products
where p.CategoryId == categoryId
orderby p.ProductName
select p;
foreach (var product in products)
{
Console.WriteLine("{0} {1} {2}",
product.Id, product.ProductName, product.Price.ToString("C"));
}
}
}
private static void SeedData()
{
using (var context = new SampleContext())
{
// Create categories
var beverages = context.Categories.Add(new Category {
CategoryName = "Beverages"
});
var condiments = context.Categories.Add(new Category {
CategoryName = "Condiments"
});
var confections = context.Categories.Add(new Category {
CategoryName = "Confections"
});
// Create beverages
context.Products.Add(new Product {
ProductName = "Chai", Price = 10, Category = beverages
});
context.Products.Add(new Product {
ProductName = "Chang", Price = 20, Category = beverages
});
context.Products.Add(new Product {
ProductName = "Ipoh Coffee", Price = 30, Category = beverages
});
// Create condiments
context.Products.Add(new Product {
ProductName = "Aniseed Syrup", Price = 40, Category = condiments
});
// Create confections
context.Products.Add(new Product {
ProductName = "Chocolade", Price = 50, Category = confections
});
context.Products.Add(new Product {
ProductName = "Maxilaku", Price = 60, Category = confections
});
// Persist changes
context.SaveChanges();
}
}
