private async Task <DataSet> FillDataset()
{
using (AdventureWorksDW2017Entities entities = new AdventureWorksDW2017Entities())
{
var data = await entities.DimEmployee.ToListAsync();
DataSet dataSet1 = new DataSet();
dataSet1.DataSetName = "EmployeeDataset";
DataTable dataTable1 = new DataTable();
dataSet1.Tables.Add(dataTable1);
dataTable1.TableName = "Employee";
dataTable1.Columns.Add("FirstName", typeof(string));
dataTable1.Columns.Add("LastName", typeof(string));
dataTable1.Columns.Add("HireDate", typeof(DateTime));
foreach (var item in data)
{
dataSet1.Tables["Employee"].Rows.Add(new Object[] { item.FirstName, item.LastName, item.HireDate });
}
return(dataSet1);
}
}
private async Task <List <Customer> > getData()
{
using (AdventureWorksDW2017Entities entities = new AdventureWorksDW2017Entities())
{
List <Customer> customerList = new List <Customer>();
var data = await entities.DimCustomer.Take(200).ToListAsync();
foreach (var item in data)
{
Customer modelo = new Customer();
modelo.Phone = item.Phone;
modelo.CustomerKey = item.CustomerKey;
modelo.FirstName = item.FirstName;
modelo.LastName = item.LastName;
modelo.EmailAddress = item.EmailAddress;
customerList.Add(modelo);
}
return(customerList);
}
}
