public void ImportData(EbDataSet dataSet)
{
EbLog.Info("Importing Data to local DB...");
if (dataSet?.Tables.Count > 0)
{
EbLog.Info($"Importing {dataSet?.Tables.Count} Tables");
foreach (EbDataTable dt in dataSet.Tables)
{
EbLog.Info($"Importing Tables {dt.TableName} with {dt.Rows.Count} records");
List <SQLiteColumSchema> ColSchema = new List <SQLiteColumSchema>();
foreach (EbDataColumn col in dt.Columns)
{
ColSchema.Add(new SQLiteColumSchema
{
ColumnName = col.ColumnName,
ColumnType = SQLiteTableSchema.SQLiteType(col.Type)
});
}
DropTable(dt.TableName);
EbLog.Info($"{dt.TableName} droped.");
CreateTable(dt.TableName, ColSchema);
EbLog.Info($"{dt.TableName} created.");
App.DataDB.DoNonQueryBatch(dt);
EbLog.Info($"Importing Tables {dt.TableName} complete.");
}
}
}
