private static void CreateCustomerWithOrder() { var products = GetProducts(); var product1 = products[0]; var product2 = products[1]; var customer = new Customer { FirstName = "Julie", LastName = "Lerman", ContactDetail = new ContactDetail { TwitterAlias = "julielerman" }, DateOfBirth = DateTime.Now }; var order = new Order { DestinationLatLong = DbGeography.FromText("POINT(44.292401 -72.968102)"), OrderDate = DateTime.Now, OrderSource = OrderSource.InPerson, LineItems = { new LineItem { ProductId = product1.ProductId, Quantity = 2 }, new LineItem { ProductId = product2.ProductId, Quantity = 1 } } }; customer.Orders.Add(order); using (var context = new SalesModelContext()) { context.Customers.Add(customer); context.SaveChanges(); } }
private static void InsertCustomer() { using (var ctx = new SalesModelContext()) { var customer = new Customer { FirstName = "First", LastName = "Last", DateOfBirth = new DateTime(1980, 1, 5) }; ctx.Customers.Add(customer); ctx.SaveChanges(); } }
private static void InsertCustomer() { var customer = new Customer { FirstName = "Julie", LastName = "Lerman", DateOfBirth = DateTime.Now }; using (var context = new SalesModelContext()) { context.Customers.Add(customer); context.SaveChanges(); } GetCustomer(customer.CustomerId); }
private static void UpdateCustomer() { int id; using (var context = new SalesModelContext()) { var customer = context.Customers .FirstOrDefault(c => c.FirstName == "Julie"); id = customer.CustomerId; Console.WriteLine(customer.DateOfBirth); customer.DateOfBirth = DateTime.Now.AddYears(-25); context.SaveChanges(); } GetCustomer(id); }
private static void DeleteJulie() { using (var context = new SalesModelContext()) { var julies = context.Customers .Where(c => c.FirstName == "Julie") .ToList(); foreach (var customer in julies) { context.Customers.Remove(customer); } context.SaveChanges(); } GetCustomers(); }