private static void EagerLoadingDemo() { using (var entities = new Formula1v2Entities()) { foreach (Racer racer in entities.Racers.Include("RaceResults.Race.Circuit")) { Console.WriteLine("{0} {1}", racer.FirstName, racer.LastName); foreach (RaceResult raceResult in racer.RaceResults) { Console.WriteLine("\t{0} {1:d} {2}", raceResult.Race.Circuit.Name, raceResult.Race.Date, raceResult.Position); } } } }
private static void ChangeInformation() { using (var data = new Formula1v2Entities()) { var esteban = data.Racers.Create(); esteban.FirstName = "Esteban"; esteban.LastName = "Gutierrez"; esteban.Nationality = "Mexico"; esteban.Starts = 0; data.Racers.Add(esteban); var fernando = data.Racers.First(racer => racer.LastName == "Alonso"); fernando.Wins++; fernando.Starts++; foreach (var entry in data.ChangeTracker.Entries <Racer>()) { Console.WriteLine("{0}, state: {1}", entry.Entity, entry.State); if (entry.State == EntityState.Modified) { Console.WriteLine("Original values"); DbPropertyValues values = entry.OriginalValues; foreach (var propertyName in values.PropertyNames) { Console.WriteLine("{0} {1}", propertyName, values[propertyName]); } Console.WriteLine(); Console.WriteLine("Current values"); values = entry.CurrentValues; foreach (var propertyName in values.PropertyNames) { Console.WriteLine("{0} {1}", propertyName, values[propertyName]); } } } } }