Exemplo n.º 1
0
        private static void SeedData()
        {
            using (var context = new MappingContext())
            {
                // 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", Category = confections });
                context.Products.Add(new Product { ProductName = "Maxilaku", Category = confections });

                // Persist changes
                context.SaveChanges();
            }
        }
Exemplo n.º 2
0
        private static void ShowData()
        {
            using (var context = new MappingContext())
            {
                Console.WriteLine("\nCategories:");
                foreach (var c in context.Categories)
                {
                    Console.WriteLine("{0} {1}", c.CategoryIdentifier, c.CategoryName);
                }

                Console.WriteLine("\nProducts:");
                foreach (var p in context.Products)
                {
                    Console.WriteLine("{0} {1} {2} {3}", p.ProductIdentifier, p.ProductName,
                        p.Price, p.Category.CategoryName);
                }
            }
        }