public async Task <IEnumerable <T> > FindList <T>(string strSql, DbParameter[] dbParameter) where T : class { using (var dbConnection = dbContext.Database.GetDbConnection()) { var reader = await new DbHelper(dbContext, dbConnection).ExecuteReadeAsync(CommandType.Text, strSql, dbParameter); return(DatabasesExtension.IDataReaderToList <T>(reader)); } }
public async Task LinqGetSqlTest() { string sort = "RoleSort"; bool isAsc = false; int pageSize = 10; int pageIndex = 1; RepositoryFactory repositoryFactory = new RepositoryFactory(); var tempData = repositoryFactory.BaseRepository().db.dbContext.Set <RoleEntity>().AsQueryable(); tempData = DatabasesExtension.AppendSort <RoleEntity>(tempData, sort, isAsc); tempData = tempData.Skip <RoleEntity>(pageSize * (pageIndex - 1)).Take <RoleEntity>(pageSize).AsQueryable(); string strSql = DatabasesExtension.GetSql <RoleEntity>(tempData); Assert.IsTrue(strSql.ToUpper().Contains("SELECT")); }
public async Task <int> Update <T>(T entity) where T : class { dbContext.Set <T>().Attach(entity); Hashtable props = DatabasesExtension.GetPropertyInfo <T>(entity); foreach (string item in props.Keys) { if (item == "Id") { continue; } object value = dbContext.Entry(entity).Property(item).CurrentValue; if (value != null) { dbContext.Entry(entity).Property(item).IsModified = true; } } return(dbContextTransaction == null ? await this.CommitTrans() : 0); }