public void ImportData(GenericInstance source, bool isTruncate)
{
throw new NotImplementedException();
}
public void ImportData(GenericInstance source, bool isTruncate)
{
using (var connection = DbAccessHelper.CreateDbConnection(
source.ProviderName, source.ConnectionString))
{
connection.Open();
foreach (var table in source.Tables)
{
if (!table.IsForImport)
continue;
var mappings = ExtractColumnMappings(table);
var selectCommandText = ConstructSelectCommand(table);
var selectCommand = DbAccessHelper.CreateCommand(selectCommandText, connection);
using (var reader = selectCommand.ExecuteReader())
{
var importer = new SqlImporter(reader);
importer.StatusUpdated += ImportStatusChanged;
importer.TargetConnectionString = base._connectionString;
importer.TargetTableName = table.MappingTableName;
importer.Mappings = mappings;
importer.Import(isTruncate);
}
}
connection.Close();
}
}
