static void Main(string[] args) { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter6.weborder"); } using (var context = new EFRecipesEntities()) { var order = new WebOrder { CustomerName = "Jim Allen", OrderDate = DateTime.Parse("5/3/2009"), IsDeleted = false, Amount = 200 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "John Stevens", OrderDate = DateTime.Parse("1/1/2006"), IsDeleted = false, Amount = 400 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "Russel Smith", OrderDate = DateTime.Parse("1/3/2006"), IsDeleted = true, Amount = 500 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "Mike Hammer", OrderDate = DateTime.Parse("3/6/2006"), IsDeleted = true, Amount = 1800 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "Steve Jones", OrderDate = DateTime.Parse("1/1/2003"), IsDeleted = true, Amount = 600 }; context.WebOrders.AddObject(order); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Orders"); Console.WriteLine("======"); foreach (var order in context.WebOrders) { Console.WriteLine("\nCustomer: {0}", order.CustomerName); Console.WriteLine("OrderDate: {0}", order.OrderDate.ToShortDateString()); Console.WriteLine("Is Deleted: {0}", order.IsDeleted.ToString()); Console.WriteLine("Amount: {0}", order.Amount.ToString("C")); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var park = new Park { Name = "11th Street Park", Address = "801 11th Street", City = "Aledo", State = "TX", ZIPCode = "76106" }; var loc = new Location { Address = "501 Main", City = "Weatherford", State = "TX", ZIPCode = "76201" }; park.Office = loc; context.Locations.AddObject(park); park = new Park { Name = "Overland Park", Address = "101 High Drive", City = "Springtown", State = "TX", ZIPCode = "76081" }; loc = new Location { Address = "8705 Range Lane", City = "Springtown", State = "TX", ZIPCode = "76081" }; park.Office = loc; context.Locations.AddObject(park); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { context.ContextOptions.LazyLoadingEnabled = true; Console.WriteLine("-- All Locations -- "); foreach (var l in context.Locations) { Console.WriteLine("{0}, {1}, {2} {3}", l.Address, l.City, l.State, l.ZIPCode); } Console.WriteLine("--- Parks ---"); foreach (var p in context.Locations.OfType <Park>()) { Console.WriteLine("{0} is at {1} in {2}", p.Name, p.Address, p.City); Console.WriteLine("\tOffice: {0}, {1}, {2} {3}", p.Office.Address, p.Office.City, p.Office.State, p.Office.ZIPCode); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { context.ParkingTickets.AddObject(new ParkingTicket { Amount = 132.0M, Paid = false }); context.ParkingTickets.AddObject(new ParkingTicket { Amount = 255.0M, Paid = false }); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { foreach (var ticket in context.ParkingTickets) { Console.WriteLine("Ticket: {0}", ticket.TicketId); Console.WriteLine("Date: {0}", ticket.CreateDate.ToShortDateString()); Console.WriteLine("Amount: {0}", ticket.Amount.ToString("C")); Console.WriteLine("Paid: {0}", ticket.PaidDate.HasValue ? ticket.PaidDate.Value.ToShortDateString() : "Not Paid"); Console.WriteLine(); ticket.Paid = true; // just paid ticket! } // save all those Paid flags context.SaveChanges(); foreach (var ticket in context.ParkingTickets) { Console.WriteLine("Ticket: {0}", ticket.TicketId); Console.WriteLine("Date: {0}", ticket.CreateDate.ToShortDateString()); Console.WriteLine("Amount: {0}", ticket.Amount.ToString("C")); Console.WriteLine("Paid: {0}", ticket.PaidDate.HasValue ? ticket.PaidDate.Value.ToShortDateString() : "Not Paid"); Console.WriteLine(); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var worker1 = new Worker { Name = "John Kearney" }; var worker2 = new Worker { Name = "Nancy Roberts" }; var worker3 = new Worker { Name = "Karla Gibbons" }; context.Accidents.AddObject(new Accident { Description = "Cuts and contusions", Severity = 3, Worker = worker1 }); context.Accidents.AddObject(new Accident { Description = "Broken foot", Severity = 4, Worker = worker1 }); context.Accidents.AddObject(new Accident { Description = "Fall, no injuries", Severity = 1, Worker = worker2 }); context.Accidents.AddObject(new Accident { Description = "Minor burn", Severity = 3, Worker = worker2 }); context.Accidents.AddObject(new Accident { Description = "Back strain", Severity = 2, Worker = worker3 }); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { context.ContextOptions.LazyLoadingEnabled = false; var query = from w in context.Workers select new { Worker = w, Accidents = w.Accidents.Where(a => a.Severity > 2) }; query.ToList(); var workers = query.Select(r => r.Worker); Console.WriteLine("Workers with serious accidents..."); foreach (var worker in workers) { Console.WriteLine("{0} had the following accidents", worker.Name); if (worker.Accidents.Count == 0) { Console.WriteLine("\t--None--"); } foreach (var accident in worker.Accidents) { Console.WriteLine("\t{0}, severity: {1}", accident.Description, accident.Severity.ToString()); } } } Console.WriteLine(); using (var context = new EFRecipesEntities()) { context.ContextOptions.LazyLoadingEnabled = false; foreach (var worker in context.Workers) { Console.WriteLine("{0} had the following accidents", worker.Name); var accidents = worker.Accidents.CreateSourceQuery().Where(a => a.Severity > 2); worker.Accidents.Attach(accidents); if (worker.Accidents.Count == 0) { Console.WriteLine("\t--None--"); } foreach (var accident in accidents) { Console.WriteLine("\t{0}, severity: {1}", accident.Description, accident.Severity.ToString()); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }