private void ExecuteOperation(EntityState entityState, IEnumerable <TEntity> items) { using (var context = new PolitermUsers()) { foreach (TEntity entity in items) { context.Entry(entity).State = entityState; } context.SaveChanges(); } }
public virtual IList <TEntity> Create(IEnumerable <TEntity> items) { using (var context = new PolitermUsers()) { DbSet <TEntity> set = context.Set <TEntity>(); foreach (TEntity entity in items) { set.Add(entity); } context.SaveChanges(); } return(items.ToList()); }
public virtual IList <TEntity> GetAll(IEnumerable <Expression <Func <TEntity, object> > > navigationProperties) { IList <TEntity> list; using (var context = new PolitermUsers()) { IQueryable <TEntity> dbQuery = context.Set <TEntity>(); foreach (Expression <Func <TEntity, object> > navigationProperty in navigationProperties) { dbQuery = dbQuery.Include(navigationProperty); } list = dbQuery.AsNoTracking().ToList(); } return(list); }
public virtual TEntity GetItem(Func <TEntity, bool> where, IEnumerable <Expression <Func <TEntity, object> > > navigationProperties) { TEntity entity = null; using (var context = new PolitermUsers()) { IQueryable <TEntity> dbQuery = context.Set <TEntity>(); foreach (Expression <Func <TEntity, object> > navigationProperty in navigationProperties) { dbQuery = dbQuery.Include(navigationProperty); } entity = dbQuery.AsNoTracking().FirstOrDefault(where); } return(entity); }
public BaseDto GetDatabaseData() { try { StringBuilder sb = new StringBuilder(); DatabaseDto databaseDto = new DatabaseDto(); databaseDto.SourceName = "PolitermUsers"; sb.Append("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES "); sb.Append("WHERE TABLE_NAME NOT LIKE '__MigrationHistory' "); sb.Append("ORDER BY(TABLE_NAME)"); List <string> tableNames; using (PolitermUsers db = new PolitermUsers()) { tableNames = db.Database.SqlQuery <string>(sb.ToString()).ToList(); sb.Clear(); foreach (var tableName in tableNames) { sb.AppendLine("SELECT COLUMN_NAME "); sb.AppendLine("FROM INFORMATION_SCHEMA.COLUMNS "); sb.AppendFormat("WHERE TABLE_NAME = '{0}'", tableName); databaseDto.Tables.Add(new TableDto { TableName = tableName, ColumnNames = db.Database.SqlQuery <string>(sb.ToString()).ToList() }); sb.Clear(); } } return(databaseDto); } catch (Exception ex) { throw new FaultException <Exception>(ex, ex.Message); } }