private void BDeleteRecords_Click(object sender, EventArgs e) { tBExtId.Clear(); tBEditExt.Clear(); using (var db = new ExtensionContext()) { var query = from c in db.ExtensionDB select new { c.ListId }; if (query.ToList().Count >= 1) { foreach (var item in query) { using (var dbx = new ExtensionContext()) { int x = Convert.ToInt32(item.ListId.ToString()); var delete = new ListExtension.List { ListId = x }; dbx.ExtensionDB.Attach(delete); dbx.ExtensionDB.Remove(delete); dbx.SaveChanges(); } } } RefleshDataGrid(); } }
private void BAddExt_Click(object sender, EventArgs e) { using (var db = new ExtensionContext()) { var Record = new ListExtension.List { Extension = tBAddExt.Text.Trim() }; db.ExtensionDB.Add(Record); db.SaveChanges(); } RefleshDataGrid(); }