/// <summary> /// Delete from DB (if exists) /// </summary> /// <param name="item">object to delete</param> public void Delete(T item) { try { using (var db = new TimeMeasurementDbContext()) { db.Set <T>().Attach(item); db.Set <T>().Remove(item); db.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); } }
/// <summary> /// Update in DB (if exists) /// </summary> /// <param name="item">object to update</param> public void Update(T item) { try { Validator.ValidateObject(item, new ValidationContext(item)); using (var db = new TimeMeasurementDbContext()) { db.Set <T>().Attach(item); db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); } }
/// <summary> /// Insert into DB (id must be 0) /// </summary> /// <param name="item">object to insert</param> public void Create(T item) { try { Validator.ValidateObject(item, new ValidationContext(item), true); using (var db = new TimeMeasurementDbContext()) { db.Set <T>().Attach(item); db.Set <T>().Add(item); db.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); } }