private static void TestLocal() { int desertSunId; using (var db = new LinqContext()) { var startCity = 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" }; db.Clubs.Add(startCity); db.Clubs.Add(desertSun); db.Clubs.Add(palmTree); db.SaveChanges(); desertSunId = desertSun.ClubId; } using (var db = new LinqContext()) { Console.WriteLine("\nLocal Collection Behavior"); Console.WriteLine("==============="); Console.WriteLine($"\nNumber of Clubs Contained in Local Collection:{db.Clubs.Local.Count}"); Console.WriteLine("================"); Console.WriteLine("\nClubs Retrived from Context Object"); Console.WriteLine("================"); foreach (var club in db.Clubs.Take(2)) { Console.WriteLine($"{club.Name} is located in {club.City}"); } Console.WriteLine("\nClubs Contained in Context Local Collection"); Console.WriteLine("================="); foreach (var club in db.Clubs.Local) { Console.WriteLine($"{club.Name} is located in {club.City}"); } db.Clubs.Find(desertSunId); Console.WriteLine("\nClubs Retrived form Context Object - Revisted"); Console.WriteLine("==============="); foreach (var club in db.Clubs) { Console.WriteLine($"{club.Name} is located in {club.City}"); } Console.WriteLine("\nClubs Contained in Context Local Collection - Revisted"); Console.WriteLine("=============="); foreach (var club in db.Clubs.Local) { Console.WriteLine($"{club.Name} is localed in {club.City}"); } var localClubs = db.Clubs.Local; var lonesomePintId = -999; localClubs.Add(new Club { City = "Portland", Name = "Lonesone Pine", ClubId = lonesomePintId }); localClubs.Remove(db.Clubs.Find(desertSunId)); Console.WriteLine("\nClub Contained in Context Object - After Adding and Deleting"); Console.WriteLine("============="); foreach (var club in db.Clubs) { Console.WriteLine($"{club.Name} is located in {club.City} with a Entity State of {db.Entry(club).State}"); } Console.WriteLine("\nClubs Contained in Context Local Collection - After Adding and Deleting"); Console.WriteLine("============="); foreach (var club in localClubs) { Console.WriteLine($"{club.Name} is located in {club.City} with a Entity State of {db.Entry(club).State}"); } Console.WriteLine("\nPress <enter> to continue"); Console.ReadLine(); } }