예제 #1
0
 /// <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);
     }
 }
예제 #2
0
 /// <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);
     }
 }
예제 #3
0
 /// <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);
     }
 }
예제 #4
0
        /// <summary>
        /// Get Objects from the DB
        /// </summary>
        /// <param name="predicate">The WHERE clause</param>
        /// <param name="includes">Objects to include</param>
        /// <returns>All entites matching the WHERE clause and the data requested in includes</returns>
        public IEnumerable <T> Get(Expression <Func <T, bool> > predicate = null, params Expression <Func <T, object> >[] includes)
        {
            try
            {
                using (var db = new TimeMeasurementDbContext())
                {
                    var query = (IQueryable <T>)db.Set <T>();
                    // ReSharper disable once InvertIf
                    if (includes != null)
                    {
                        query = includes.Aggregate(query, (current, include) => current.Include(include));
                    }

                    return(predicate == null?query.ToList() : query.Where(predicate).ToList());
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                return(null);
            }
        }