static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter6.member"); } }
static void RunExample() { using (var context = new EFRecipesEntities()) { var blogpost = new BlogPosting { Title = "ASP.NET MVC", Author = "Steven Grace", Post = "What's New", Comments = "50" }; var story = new Story { Title = "Time in a Bottle", Author = "Emily Jones", Plot = "Murder on the high seas" }; var ed = new EducationalVideo { Instructor = "Joseph Robins", ResourcePath = "\\videos\asp.wmv", Title = "ASP.NET Examples" }; var movie = new RecreationalVideo { Title = "Archie's Place", Rating = 1, ResourcePath = "\\videos\archie.wmv" }; context.Media.AddObject(blogpost); context.Media.AddObject(story); context.Media.AddObject(ed); context.Media.AddObject(movie); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("All of the media..."); foreach (var m in context.Media) { Console.WriteLine(); if (m is BlogPosting) { var post = (BlogPosting)m; Console.WriteLine("Blog Posting"); Console.WriteLine("Title: {0}, Author: {1}, Post: {2}", post.Title, post.Author, post.Post); } else if (m is Story) { var story = (Story)m; Console.WriteLine("Story"); Console.WriteLine("Title: {0}, Author: {1}, Plot: {2}", story.Title, story.Author, story.Plot); } else if (m is EducationalVideo) { var edvideo = (EducationalVideo)m; Console.WriteLine("Educational Video"); Console.WriteLine("Title: {0}, Instructor: {1}", edvideo.Title, edvideo.Instructor); } else if (m is RecreationalVideo) { var video = (RecreationalVideo)m; Console.WriteLine("Recreational Video"); Console.WriteLine("Title: {0}, Rating: {1}", video.Title, video.Rating.ToString()); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter13.track"); context.ExecuteStoreCommand("delete from chapter13.cd"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter5.invoice"); context.ExecuteStoreCommand("delete from chapter5.client"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter3.topselling"); context.ExecuteStoreCommand("delete from chapter3.product"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter12.salesorder"); context.ExecuteStoreCommand("delete from chapter12.customer"); } }
private static void Cleanup() { using (var context = new EFRecipesEntities()) { context.Database.ExecuteSqlCommand("delete from chapter5.appointment"); context.Database.ExecuteSqlCommand("delete from chapter5.doctor"); context.Database.ExecuteSqlCommand("delete from chapter5.patient"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter15.article"); context.ExecuteStoreCommand("delete from chapter15.video"); context.ExecuteStoreCommand("delete from chapter15.media"); } }
static void RunExample() { using (var context = new EFRecipesEntities()) { var cd1 = context.CreateObject <CD>(); cd1.Title = "Abbey Road"; cd1.Tracks.Add(new Track { Title = "Come Together", Artist = "The Beatles" }); var cd2 = context.CreateObject <CD>(); cd2.Title = "Cowboy Town"; cd2.Tracks.Add(new Track { Title = "Cowgirls Don't Cry", Artist = "Brooks & Dunn" }); var cd3 = context.CreateObject <CD>(); cd3.Title = "Long Black Train"; cd3.Tracks.Add(new Track { Title = "In My Dreams", Artist = "Josh Turner" }); cd3.Tracks.Add(new Track { Title = "Jacksonville", Artist = "Josh Turner" }); context.CDs.AddObject(cd1); context.CDs.AddObject(cd2); context.CDs.AddObject(cd3); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { // trigger proxy generation context.CreateProxyTypes(new Type[] { typeof(CD), typeof(Track) }); Console.WriteLine("{0} proxies generated!", EFRecipesEntities.GetKnownProxyTypes().Count()); var cds = context.CDs.Include("Tracks"); foreach (var cd in cds) { Console.WriteLine("Album: {0}", cd.Title); foreach (var track in cd.Tracks) { Console.WriteLine("\t{0} by {1}", track.Title, track.Artist); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var teen = new Teen { Name = "Steven Keller", Age = 17, Phone = "817 867-5309" }; var adult = new Adult { Name = "Margret Jones", Age = 53, Phone = "913 294-6059" }; var senior = new Senior { Name = "Roland Park", Age = 71, Phone = "816 353-4458" }; context.Members.AddObject(teen); context.Members.AddObject(adult); context.Members.AddObject(senior); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Club Members"); Console.WriteLine("============"); foreach (var member in context.Members) { bool printPhone = true; string str = string.Empty; if (member is Teen) { str = " a Teen"; printPhone = false; } else if (member is Adult) { str = "an Adult"; } else if (member is Senior) { str = "a Senior"; } Console.WriteLine("{0} is {1} member, phone: {2}", member.Name, str, printPhone ? member.Phone : "unavailable"); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var w1 = new WebProduct { Name = "Camping Tent", Description = "Family Camping Tent, Color Green" }; var w2 = new WebProduct { Name = "Chemical Light" }; var w3 = new WebProduct { Name = "Ground Cover", Description = "Blue ground cover" }; context.WebProducts.AddObject(w1); context.WebProducts.AddObject(w2); context.WebProducts.AddObject(w3); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Query using eSql..."); var esql = @"select value EFRecipesModel.Store.ISNULL(p.Description,p.Name) from EFRecipesEntities.WebProducts as p"; var prods = context.CreateQuery <string>(esql); foreach (var prod in prods) { Console.WriteLine("Product Description: {0}", prod); } } using (var context = new EFRecipesEntities()) { Console.WriteLine(); Console.WriteLine("Query using LINQ..."); var prods = from p in context.WebProducts select BuiltinFunctions.ISNULL(p.Description, p.Name); foreach (var prod in prods) { Console.WriteLine(prod); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var name1 = new Name { FirstName = "Robin", LastName = "Rosen" }; var name2 = new Name { FirstName = "Alex", LastName = "St. James" }; var address1 = new Address { AddressLine1 = "510 N. Grant", AddressLine2 = "Apt. 8", City = "Raytown", State = "MO", ZIPCode = "64133" }; var address2 = new Address { AddressLine1 = "222 Baker St.", AddressLine2 = "Apt.22B", City = "Raytown", State = "MO", ZIPCode = "64133" }; context.Agents.AddObject(new Agent { Name = name1, Address = address1 }); context.Agents.AddObject(new Agent { Name = name2, Address = address2 }); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Agents"); foreach (var agent in context.Agents) { Console.WriteLine("{0} {1}", agent.Name.FirstName, agent.Name.LastName); Console.WriteLine("{0}", agent.Address.AddressLine1); Console.WriteLine("{0}", agent.Address.AddressLine2); Console.WriteLine("{0}, {1} {2}", agent.Address.City, agent.Address.State, agent.Address.ZIPCode); Console.WriteLine(); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var client1 = new Client { Name = "Karen Standfield", ClientId = 1 }; var invoice1 = new Invoice { InvoiceDate = DateTime.Parse("4/1/10"), Amount = 29.95M }; var invoice2 = new Invoice { InvoiceDate = DateTime.Parse("4/2/10"), Amount = 49.95M }; var invoice3 = new Invoice { InvoiceDate = DateTime.Parse("4/3/10"), Amount = 102.95M }; var invoice4 = new Invoice { InvoiceDate = DateTime.Parse("4/4/10"), Amount = 45.99M }; // add the invoice // to the client's collection client1.Invoices.Add(invoice1); // assign the foreign key // directly invoice2.ClientId = 1; // Attach() and existing // row using a "fake" entity context.ExecuteStoreCommand("insert into chapter5.client values (2, 'Phil Marlowe')"); var client2 = new Client { ClientId = 2 }; context.Clients.Attach(client2); invoice3.Client = client2; // using the ClientReference invoice4.ClientReference.Value = client1; // save the changes context.Clients.AddObject(client1); context.Invoices.AddObject(invoice2); context.Invoices.AddObject(invoice3); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { foreach (var client in context.Clients) { Console.WriteLine("Client: {0}", client.Name); foreach (var invoice in client.Invoices) { Console.WriteLine("\t{0} for {1}", invoice.InvoiceDate.ToShortDateString(), invoice.Amount.ToString("C")); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
private static void RunExample() { using (var context = new EFRecipesEntities()) { var doc1 = new Doctor { Name = "Joan Meyers" }; var doc2 = new Doctor { Name = "Steven Mills" }; var pat1 = new Patient { Name = "Bill Rivers" }; var pat2 = new Patient { Name = "Susan Stevenson" }; var pat3 = new Patient { Name = "Roland Marcy" }; var app1 = new Appointment { Date = DateTime.Today, Doctor = doc1, Fee = 109.92M, Patient = pat1, Reason = "Checkup" }; var app2 = new Appointment { Date = DateTime.Today, Doctor = doc2, Fee = 129.87M, Patient = pat2, Reason = "Arm Pain" }; var app3 = new Appointment { Date = DateTime.Today, Doctor = doc1, Fee = 99.23M, Patient = pat3, Reason = "Back Pain" }; context.Appointments.Add(app1); context.Appointments.Add(app2); context.Appointments.Add(app3); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { // disable lazy-loading feature as we are explicitly loading // child entities context.Configuration.LazyLoadingEnabled = false; var doctorJoan = context.Doctors.First(o => o.Name == "Joan Meyers"); if (!context.Entry(doctorJoan).Collection(x => x.Appointments).IsLoaded) { context.Entry(doctorJoan).Collection(x => x.Appointments).Load(); Console.WriteLine("Dr. {0}'s appointments were explicitly loaded.", doctorJoan.Name); } Console.WriteLine("Dr. {0} has {1} appointment(s).", doctorJoan.Name, doctorJoan.Appointments.Count()); foreach (var appointment in context.Appointments) { if (!context.Entry(appointment).Reference(x => x.Doctor).IsLoaded) { context.Entry(appointment).Reference(x => x.Doctor).Load(); Console.WriteLine("Dr. {0} was explicitly loaded.", appointment.Doctor.Name); } else { Console.WriteLine("Dr. {0} was already loaded.", appointment.Doctor.Name); } } Console.WriteLine("There are {0} appointments for Dr. {1}", doctorJoan.Appointments.Count(), doctorJoan.Name); doctorJoan.Appointments.Clear(); Console.WriteLine("Collection clear()'ed"); Console.WriteLine("There are now {0} appointments for Dr. {1}", doctorJoan.Appointments.Count(), doctorJoan.Name); context.Entry(doctorJoan).Collection(x => x.Appointments).Load(); Console.WriteLine("Collection loaded()'ed"); Console.WriteLine("There are now {0} appointments for Dr. {1}", doctorJoan.Appointments.Count().ToString(), doctorJoan.Name); // Currently, there isn't an easy way to refresh entities with the DbContext API. // Instead, drop-down into the ObjectContext and perform the following actions var objectContext = ((IObjectContextAdapter)context).ObjectContext; var objectSet = objectContext.CreateObjectSet <Appointment>(); objectSet.MergeOption = MergeOption.OverwriteChanges; objectSet.Load(); Console.WriteLine("Collection loaded()'ed with MergeOption.OverwriteChanges"); Console.WriteLine("There are now {0} appointments for Dr. {1}", doctorJoan.Appointments.Count(), doctorJoan.Name); } // Demonstrating loading part of the collection then Load()'ing the rest using (var context = new EFRecipesEntities()) { // disable lazy-loading feature as we are explicitly loading // child entities context.Configuration.LazyLoadingEnabled = false; // Load the first doctor and attach just the first appointment var doctorJoan = context.Doctors.First(o => o.Name == "Joan Meyers"); context.Entry(doctorJoan).Collection(x => x.Appointments).Query().Take(1).Load(); // note that IsLoaded returns false here since all related data has not been loaded into the context var appointmentsLoaded = context.Entry(doctorJoan).Collection(x => x.Appointments).IsLoaded; Console.WriteLine("Dr. {0} has {1} appointments loaded.", doctorJoan.Name, doctorJoan.Appointments.Count()); // When we need all of the remaining appointments, simply Load() them context.Entry(doctorJoan).Collection(x => x.Appointments).Load(); Console.WriteLine("Dr. {0} has {1} appointments loaded.", doctorJoan.Name, doctorJoan.Appointments.Count()); } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var p1 = new Product { Name = "Trailrunner Backpack" }; var p2 = new Product { Name = "Green River Tent", TopSelling = new TopSelling { Rating = 3 } }; var p3 = new Product { Name = "Prairie Home Dutch Oven", TopSelling = new TopSelling { Rating = 4 } }; var p4 = new Product { Name = "QuickFire Fire Starter", TopSelling = new TopSelling { Rating = 2 } }; context.Products.AddObject(p1); context.Products.AddObject(p2); context.Products.AddObject(p3); context.Products.AddObject(p4); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { var products = from p in context.Products orderby p.TopSelling.Rating descending select p; Console.WriteLine("Top selling products sorted by rating"); foreach (var product in products) { if (product.TopSelling != null) { Console.WriteLine("\t{0} [rating: {1}]", product.Name, product.TopSelling.Rating.ToString()); } } } using (var context = new EFRecipesEntities()) { var products = from p in context.Products join t in context.TopSellings on p.ProductId equals t.ProductId into g from tps in g.DefaultIfEmpty() orderby tps.Rating descending select new { Name = p.Name, Rating = tps.Rating == null ? 0 : tps.Rating }; Console.WriteLine("\nTop selling products sorted by rating"); foreach (var product in products) { if (product.Rating != 0) { Console.WriteLine("\t{0} [rating: {1}]", product.Name, product.Rating.ToString()); } } } using (var context = new EFRecipesEntities()) { var esql = @"select value p from products as p order by case when p.TopSelling is null then 0 else p.TopSelling.Rating end desc"; var products = context.CreateQuery <Product>(esql); Console.WriteLine("\nTop selling products sorted by rating"); foreach (var product in products) { if (product.TopSelling != null) { Console.WriteLine("\t{0} [rating: {1}]", product.Name, product.TopSelling.Rating.ToString()); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { // bad order date using (var context = new EFRecipesEntities()) { var customer = new Customer { Name = "Phil Marlowe" }; var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/18"), Amount = 19.95M, Status = "Approved", ShippingCharge = 3.95M, Customer = customer }; context.Customers.AddObject(customer); try { context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } // order shipped before it was ordered using (var context = new EFRecipesEntities()) { var customer = new Customer { Name = "Phil Marlowe" }; var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/10"), Amount = 19.95M, Status = "Approved", ShippingCharge = 3.95M, Customer = customer }; context.Customers.AddObject(customer); context.SaveChanges(); try { order.Shipped = true; order.ShippedDate = DateTime.Parse("3/10/10"); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } // order shipped, but not approved using (var context = new EFRecipesEntities()) { var customer = new Customer { Name = "Phil Marlowe" }; var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/10"), Amount = 19.95M, Status = "Pending", ShippingCharge = 3.95M, Customer = customer }; context.Customers.AddObject(customer); context.SaveChanges(); try { order.Shipped = true; order.ShippedDate = DateTime.Parse("3/13/10"); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } // order over $5,000 and shipping not free using (var context = new EFRecipesEntities()) { var customer = new Customer { Name = "Phil Marlowe" }; var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/10"), Amount = 6200M, Status = "Approved", ShippingCharge = 59.95M, Customer = customer }; context.Customers.AddObject(customer); context.SaveChanges(); try { order.Shipped = true; order.ShippedDate = DateTime.Parse("3/13/10"); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } // order deleted after it was shipped using (var context = new EFRecipesEntities()) { var customer = new Customer { Name = "Phil Marlowe" }; var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/10"), Amount = 19.95M, Status = "Approved", ShippingCharge = 3.95M, Customer = customer }; context.Customers.AddObject(customer); context.SaveChanges(); order.Shipped = true; order.ShippedDate = DateTime.Parse("3/13/10"); context.SaveChanges(); try { context.DeleteObject(order); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }