public async Task <IEnumerable <Product> > GetAllProducts() { return(await WithConnection(async conn => { var query = await _dapperHelper.GetAllProducts <Product>(conn, _commandText.GetProducts); return query; })); }