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