public async Task <ProductDal> GetAsync(decimal productId) { var criteria = new ProductSearchCriteria { ProductId = Convert.ToInt32(productId) }; string sql = BuildResult(Select(criteria), From(criteria), Where(criteria)); return(await OracleContextAsync.QueryForObjAsync <ProductDal>(sql)); }
public override async Task <CountDal> GetCountAsync(string select, string from, string where, string orderBy, ProductSearchCriteria criteria) { string sql = BuildCount(Select(criteria), From(criteria), Where(criteria), OrderBy(criteria)); return(await OracleContextAsync.QueryForObjAsync <CountDal>(sql)); }