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));
}
