public void DeleteItem(Func <T, bool> exp) { using (var db = new ShopDataContext()) { var item = db.GetTable <T>().FirstOrDefault(exp); if (item == null) { return; } db.GetTable <T>().DeleteOnSubmit(item); db.SubmitChanges(); } }
public List <T> All() { using (var db = new ShopDataContext()) { return(db.GetTable <T>().ToList()); } }
public T GetFirstOrDefault(Func <T, bool> exp) { using (var db = new ShopDataContext()) { return(db.GetTable <T>().FirstOrDefault(exp)); } }
public List <T> FindAll(Func <T, bool> exp) { using (var db = new ShopDataContext()) { return(db.GetTable <T>().Where(exp).ToList()); } }
public void DeleteItems(List <T> items) { using (var db = new ShopDataContext()) { db.GetTable <T>().DeleteAllOnSubmit(items); db.SubmitChanges(); } }
public void CreateItems(List <T> entities) { using (var db = new ShopDataContext()) { db.GetTable <T>().InsertAllOnSubmit(entities); db.SubmitChanges(); } }
public void CreateItem(T entity) { using (var db = new ShopDataContext()) { db.GetTable <T>().InsertOnSubmit(entity); db.SubmitChanges(); } }
public void AllColumnsShouldBeMapped() { string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=SutekiShop;Integrated Security=True"; using (var context = new ShopDataContext(connectionString)) { context.Log = Console.Out; foreach (var mappedTable in context.Mapping.GetTables().Select(x => x.RowType.Type)) { context.GetTable(mappedTable).Cast<object>().Take(0).ToList(); } } }