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