private static void Cleanup() { using (var context = new Recipe4Context()) { context.Database.ExecuteSqlCommand("delete from chapter13.reservation"); } }
private static void Cleanup() { using (var context = new Recipe4Context()) { context.Database.ExecuteSqlCommand("delete from chapter5.event"); context.Database.ExecuteSqlCommand("delete from chapter5.club"); } }
private static void RunExample() { using (var context = new Recipe4Context()) { context.Reservations.Add(new Reservation { Name = "James Jordan", ResDate = DateTime.Parse("4/18/10") }); context.Reservations.Add(new Reservation { Name = "Katie Marlowe", ResDate = DateTime.Parse("3/22/10") }); context.Reservations.Add(new Reservation { Name = "Roger Smith", ResDate = DateTime.Parse("4/18/10") }); context.Reservations.Add(new Reservation { Name = "James Jordan", ResDate = DateTime.Parse("5/12/10") }); context.Reservations.Add(new Reservation { Name = "James Jordan", ResDate = DateTime.Parse("6/22/10") }); context.SaveChanges(); } using (var context = new Recipe4Context()) { DateTime?searchDate = null; var searchName = "James Jordan"; Console.WriteLine("More complex SQL..."); var query2 = from reservation in context.Reservations let dateMatches = searchDate == null || reservation.ResDate == searchDate let nameMatches = searchName == string.Empty || reservation.Name.Contains(searchName) where dateMatches && nameMatches select reservation; foreach (var reservation in query2) { Console.WriteLine("Found reservation for {0} on {1}", reservation.Name, reservation.ResDate.ToShortDateString()); } Console.WriteLine("Cleaner SQL..."); var query1 = from reservation in context.Reservations where (searchDate == null || reservation.ResDate == searchDate) && (searchName == string.Empty || reservation.Name.Contains(searchName)) select reservation; foreach (var reservation in query1) { Console.WriteLine("Found reservation for {0} on {1}", reservation.Name, reservation.ResDate.ToShortDateString()); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
private static void RunExample() { int desertSunId; using (var context = new Recipe4Context()) { var starCity = new Club { Name = "Star City Chess Club", City = "New York" }; var desertSun = new Club { Name = "Desert Sun Chess Club", City = "Phoenix" }; var palmTree = new Club { Name = "Palm Tree Chess Club", City = "San Diego" }; context.Clubs.Add(starCity); context.Clubs.Add(desertSun); context.Clubs.Add(palmTree); context.SaveChanges(); desertSunId = desertSun.ClubId; } using (var context = new Recipe4Context()) { Console.WriteLine("\nLocal Collection Behavior"); Console.WriteLine("================="); Console.WriteLine("\nNumber of Clubs Contained in Local Collection: {0}", context.Clubs.Local.Count); Console.WriteLine("================="); Console.WriteLine("\nClubs Retrieved from Context Object"); Console.WriteLine("================="); foreach (var club in context.Clubs.Take(2)) { Console.WriteLine("{0} is located in {1}", club.Name, club.City); } Console.WriteLine("\nClubs Contained in Context Local Collection"); Console.WriteLine("================="); foreach (var club in context.Clubs.Local) { Console.WriteLine("{0} is located in {1}", club.Name, club.City); } context.Clubs.Find(desertSunId); Console.WriteLine("\nClubs Retrieved from Context Object - Revisted"); Console.WriteLine("================="); foreach (var club in context.Clubs) { Console.WriteLine("{0} is located in {1}", club.Name, club.City); } Console.WriteLine("\nClubs Contained in Context Local Collection - Revisted"); Console.WriteLine("================="); foreach (var club in context.Clubs.Local) { Console.WriteLine("{0} is located in {1}", club.Name, club.City); } // Get reference to local observable collection var localClubs = context.Clubs.Local; // Add new Club var lonesomePintId = -999; localClubs.Add(new Club { City = "Portland", Name = "Lonesome Pine", ClubId = lonesomePintId }); // Remove Desert Sun club localClubs.Remove(context.Clubs.Find(desertSunId)); Console.WriteLine("\nClubs Contained in Context Object - After Adding and Deleting"); Console.WriteLine("================="); foreach (var club in context.Clubs) { Console.WriteLine("{0} is located in {1} with a Entity State of {2}", club.Name, club.City, context.Entry(club).State); } Console.WriteLine("\nClubs Contained in Context Local Collection - After Adding and Deleting"); Console.WriteLine("================="); foreach (var club in localClubs) { Console.WriteLine("{0} is located in {1} with a Entity State of {2}", club.Name, club.City, context.Entry(club).State); } Console.WriteLine("\nPress <enter> to continue..."); Console.ReadLine(); } }