public static void deleteRecord(int ID)//deletes record based on id passed { using (CDModel context = new CDModel()) { CDtbl champion = new CDtbl { id = ID }; var cdGone = searchDB(ID); context.CDtbls.Attach(cdGone); context.CDtbls.Remove(cdGone); context.SaveChanges(); } }
public static void addRecord(string Artist, string Album, int Year) { using (CDModel context = new CDModel()) { CDtbl cd = new CDtbl() { Artist = Artist, Album = Album, Year = Year, }; context.CDtbls.Add(cd); context.SaveChanges(); } }
public static void editRecord(int id, string artist, string album, int year) { using (CDModel db = new CDModel()) { CDtbl CD = new CDtbl { id = id, Artist = artist, Album = album, Year = year }; var original = db.CDtbls.Find(CD.id); if (original != null) { db.Entry(original).CurrentValues.SetValues(CD); db.SaveChanges(); } } }