private static void DeleteContact()
{
ContactsDBDataContext db = new ContactsDBDataContext();
var deleteContact = db.Contacts.Where(c => c.Name == "HermoineGranger").First();
db.Contacts.Remove(deleteContact);
db.SaveChanges();
}
//-----------------applies to DB first -----------------------
private static void UpdateContact()
{
// Update
ContactsDBDataContext db = new ContactsDBDataContext();
var contactUpdate = db.Contacts.Find(23);
contactUpdate.Gender = "Male";
db.SaveChanges();
}
private static void Add()
{
//Add new contact
Contact c = new Contact();
c.Name = "HermoineGranger";
c.Loc = "England";
c.Gender = "F";
c.Email = "hermoinegmailcom";
ContactsDBDataContext db = new ContactsDBDataContext();
db.Contacts.Add(c);
db.SaveChanges();
}