public virtual IEnumerable <TEntity> ExecuteQuery(string query)
 {
     try
     {
         context = new UnitOfWorkDevelopmentEntities();
         dbSet   = context.Set <TEntity>();
         return(dbSet.SqlQuery(query));
     }
     catch (Exception)
     {
         return(null);
     }
 }
 public virtual void Delete(object id)
 {
     try
     {
         context = new UnitOfWorkDevelopmentEntities();
         dbSet   = context.Set <TEntity>();
         TEntity entityToDelete = dbSet.Find(id);
         Delete(entityToDelete);
     }
     catch (Exception)
     {
     }
 }
        public virtual TEntity Insert(TEntity entity)
        {
            context = new UnitOfWorkDevelopmentEntities();
            dbSet   = context.Set <TEntity>();
            var response = dbSet.Add(entity);

            context.SaveChanges();
            return(response);
            //return new Response
            //{
            //    Success = (output == 0) ? true : false,
            //    Result = output,
            //    Exception = (output != 0) ? "Error Inserting into database" : string.Empty
            //};
        }
 public virtual TEntity Update(TEntity entity)
 {
     try
     {
         context = new UnitOfWorkDevelopmentEntities();
         dbSet   = context.Set <TEntity>();
         var result = dbSet.Attach(entity);
         context.Entry(entity).State = EntityState.Modified;
         context.SaveChanges();
         return(result);
     }
     catch (Exception)
     {
         return(null);
     }
 }
 internal TEntity GetById(object id)
 {
     context = new UnitOfWorkDevelopmentEntities();
     dbSet   = context.Set <TEntity>();
     return(dbSet.Find(id));
 }