public async Task ImportFromFile(string tableName, StreamReader stream, IDataImporter importer)
{
await foreach (var table in importer.GetDatabaseTables(tableName, stream))
{
var data = await importer.GetData(stream, table);
try
{
await CreateAsync(table);
//TODO: write sql query for insert list dictionary
foreach (var d in data)
{
await InsertIntoTableByTableNameAsync(table.TableName, d);
}
}
catch (Exception e)
{
Console.WriteLine(table.DisplayName);
Console.WriteLine(e.Message);
}
}
}