private static void Edit() { using (var context = new SampleEntities()) { var contact = context.Contacts.First(); contact.FirstName = "Julia"; contact.ModifiedDate = DateTime.Now; context.SaveChanges(); } }
private static void RemoveEnitiy() { using (var context = new SampleEntities()) { var contact = context.Contacts.Find(438); if (contact != null) { context.Contacts.Remove(contact); } context.SaveChanges(); } }
private static void CreateParentChildEntity() { using (var context = new SampleEntities()) { var contact = new Contact { FirstName = "Camey", LastName = "Combs", AddDate = DateTime.Now, ModifiedDate = DateTime.Now, Addresses = new List <Address>() }; var address = new Address { Street1 = "One Main Street", City = "Olympia", StateProvince = "WA", AddressType = "Business", ModifiedDate = DateTime.Now, Contact = contact }; var contact1 = new Contact { FirstName = "Camey", LastName = "Combs", AddDate = DateTime.Now, ModifiedDate = DateTime.Now, Addresses = new List <Address> { new Address { Street1 = "One Main Street", City = "Olympia", StateProvince = "WA", AddressType = "Business", ModifiedDate = DateTime.Now } } }; context.Contacts.Add(contact1); contact.Addresses.Add(address); //join the new address to the contact //add the new graph to the context context.Contacts.Add(contact); context.SaveChanges(); } }
private static void CreateEntity() { using (var context = new SampleEntities()) { var contact = context.Contacts.First(c => c.FirstName == "Robert"); var address = new Address { Street1 = "One Main Street", City = "Burlington", StateProvince = "VT", AddressType = "Business", ModifiedDate = DateTime.Now, Contact = contact }; contact.Addresses.Add(address); //join the new address to the contact context.SaveChanges(); } }