public static List <T> Where(string connectionString, Func <T, bool> predicate) { using (MainDataContext db = new MainDataContext(connectionString)) { return(db.GetTable <T>().Where(predicate).ToList()); } }
public static T FirstOrDefault(Func <T, bool> predicate) { using (MainDataContext db = new MainDataContext()) { return(db.GetTable <T>().FirstOrDefault(predicate)); } }
public static T FirstOrDefault(string connectionString, Func <T, bool> predicate) { using (MainDataContext db = new MainDataContext(connectionString)) { return(db.GetTable <T>().FirstOrDefault(predicate)); } }
public static void Delete(string connectionString, T entity) { using (MainDataContext db = new MainDataContext(connectionString)) { try { db.GetTable <T>().Attach(entity, true); db.GetTable <T>().DeleteOnSubmit(entity); db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }
public static List <T> ToList(string connectionString) { using (MainDataContext db = new MainDataContext(connectionString)) { return(db.GetTable <T>().ToList()); } }
public static List <T> ToList() { using (MainDataContext db = new MainDataContext()) { return(db.GetTable <T>().ToList()); } }
public static void Delete(string connectionString, List <T> entity) { using (MainDataContext db = new MainDataContext(connectionString)) { try { foreach (T obj in entity) { db.GetTable <T>().Attach(obj, true); db.GetTable <T>().DeleteOnSubmit(obj); } db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }
public static void Update(string connectionString, T entity, T original) { using (MainDataContext db = new MainDataContext(connectionString)) { try { db.GetTable <T>().Attach(entity, original); db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }
public static void Update(T entity) { using (MainDataContext db = new MainDataContext()) { try { db.GetTable <T>().Attach(entity, true); db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }
public static void Insert(T entity) { using (MainDataContext db = new MainDataContext()) { try { db.GetTable <T>().InsertOnSubmit(entity); db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }
public static void Insert(List <T> entity) { using (MainDataContext db = new MainDataContext()) { try { foreach (T obj in entity) { db.GetTable <T>().InsertOnSubmit(obj); } db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }