public async Task <IList <Product> > GetProductsTask() { IList <Product> products = new List <Product>(); DataTable ds; using (ProductDataService data = new ProductDataService()) { string sql = "SELECT * FROM [Production].[Product]"; ds = await data.GetProductsAsync(sql); } products = ConvertToProducts(ds); return(products); }