public async Task <IList <T> > SelectAsync <T>(string sql, IList <Parameter> parameters = null, int timeout = 15) where T : class, new() { IEnumerable <T> result = null; using (IOrm orm = this.orm) { result = await orm.SelectAsync <T>(new SqlCommand(sql, parameters, timeout), CustomMapper.Resolve <T>()); } if (result == null) { return(null); } return(result.ToList()); }
public async Task <IList <T> > SelectAsync <T>(Expression <Func <T, bool> > expression, int timeout = 15) where T : class, new() { IEnumerable <T> result = null; using (IOrm orm = this.orm) { SqlCommand query = DynamicQuery.GetDynamicQuery(typeof(T).Name.ToLowerInvariant().Pluralize(), expression); result = await orm.SelectAsync <T>(new SqlCommand(query.Statement, query.Parameters, timeout)); } if (result == null) { return(null); } return(result.ToList()); }