private static void ReadData() { using (var context = new Context()) { var user = context.Users.Include(u => u.Address).First(); Console.WriteLine("User '{0}' lives in '{1}'", user.Name, user.Address.Street); var itinerary = context.Itineraries.Include(i => i.Addresses).First(); Console.WriteLine("Itinerary including the following addresses '{0}'", String.Join(",", itinerary.Addresses.Select(a => a.Street))); } }
private static void Initialize() { var initializer = new MigrateDatabaseToLatestVersion<Context, DbConfig>(); Database.SetInitializer(initializer); using (var context = new Context()) { context.Database.Initialize(force: true); context.SaveChanges(); } }
private static void ClearDb() { using (var context = new Context()) { foreach (var itinerary in context.Itineraries.ToList()) context.Itineraries.Remove(itinerary); foreach (var user in context.Users.Include(u => u.Address).ToList()) context.Users.Remove(user); context.SaveChanges(); } }
private static void InsertData() { var user = new User { Name = "John", Address = new Address { Street = "Victoria Avenue" } }; var itinerary = new Itinerary { Addresses = new List<Address> { user.Address } }; using (var context = new Context()) { context.Users.Add(user); context.Itineraries.Add(itinerary); context.SaveChanges(); } }
private static void SaveDbmxToDisk() { using (var context = new Context()) { var xmlWriter = new XmlTextWriter(@"..\..\SavedModel.edmx", new UTF8Encoding()); EdmxWriter.WriteEdmx(context, xmlWriter); } }