public void Delete(int id) { using (var context = new DatabaseDemoEntities()) { var item = context.Table.Find(id); context.Table.Remove(item); context.SaveChanges(); } }
public int Insert(Item item) { using (var context = new DatabaseDemoEntities()) { var tableItem = new Table { Name = item.Name }; context.Table.Add(tableItem); context.SaveChanges(); return(tableItem.Id); } }
public IEnumerable <Item> Get() { var items = new List <Item>(); using (var context = new DatabaseDemoEntities()) { items.AddRange(context.Table.Select(item => new Item { Id = item.Id, Name = item.Name })); } return(items); }