public int InsertEntities <TEntity>(params TEntity[] entities) where TEntity : class { using (var context = new SqlServerDbContext(Const.DBCONNECT)) { context.Set <TEntity>().AddRange(entities); return(context.SaveChanges()); } }
public IQueryable <TEntity> QueryEntities <TEntity>() where TEntity : class { var context = new SqlServerDbContext(Const.DBCONNECT); return(context.Set <TEntity>().AsNoTracking().AsQueryable()); }
public List <TElement> FromSql <TElement>(string sql, params object[] parameters) { using (var context = new SqlServerDbContext(Const.DBCONNECT)) { return(context.Database.SqlQuery <TElement>(sql, parameters).ToList()); } }