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 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 void Insert(string connectionString, List <T> entity) { using (MainDataContext db = new MainDataContext(connectionString)) { try { foreach (T obj in entity) { db.GetTable <T>().InsertOnSubmit(obj); } db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }
public static void Delete(List <T> entity) { using (MainDataContext db = new MainDataContext()) { try { foreach (T obj in entity) { db.GetTable <T>().Attach(obj, true); db.GetTable <T>().DeleteOnSubmit(obj); } db.SubmitChanges(); } catch (Exception ex) { throw ex; } } }