private static void SimpleOrderQueries() { using (var db = new SaleContext()) { db.Database.Log = Console.WriteLine; var orders = db.Orders.ToList(); foreach (var order in orders) { Console.WriteLine("List all orders - order Id:{0}, order cost:{1}", order.Id, order.Cost); } orders = db.Orders.Where(x => x.Cost > 250).ToList(); foreach (var order in orders) { Console.WriteLine("List cost > 250 orders - Id:{0}, order cost:{1}", order.Id, order.Cost); } int maxCost = 250; orders = db.Orders.Where(x => x.Cost > maxCost).ToList(); foreach (var order in orders) { Console.WriteLine("List cost > 250 orders - Id:{0}, order cost:{1}", order.Id, order.Cost); } } }
private static void InsertOrder() { var order = new Order { Cost = 100, CustomerId = 1 }; using (var db = new SaleContext()) { db.Orders.Add(order); db.SaveChanges(); } }
private static void InsertOrders() { var orders = new List<Order> { new Order { CustomerId = 1, Cost = 200}, new Order { CustomerId = 1, Cost = 300} }; using (var db = new SaleContext()) { db.Orders.AddRange(orders); db.SaveChanges(); } }
private static void InsertCustomer() { var customer = new Customer { Name = "Tony", DateOfBirth = DateTime.Now, Id = 1 }; using (var db = new SaleContext()) { db.Customers.Add(customer); db.SaveChanges(); } }