public void GenerateStream(Stream stream, bool disableTriggers, bool dryRun)
{
_ = Check.NotNull(nameof(stream), stream);
using var sql = new InternalGenerator(this).Generate();
var tableDescriptions = GetOrderedTableDescriptions().ToArray();
WriteStartTransaction(stream);
WriteDisableTriggers(stream, disableTriggers);
WriteDeletions(stream, tableDescriptions);
WriteInsertions(stream, sql, tableDescriptions);
WriteFinishTranscation(stream, dryRun);
}
public void GenerateDatabase(bool disableTriggers, bool dryRun)
{
var tablePrescriptions = GetOrderedTableDescriptions()
.Select(_ => _Project.Prescriptor.TablePrescriptions.SingleOrDefault(tablePrescription => tablePrescription.TableDescription == _))
.ToArray();
using var source = new InternalGenerator(this).Generate();
using var destination = _SqlFactory.Open(_Project.Descriptor.ConnectionString);
using var sourceConnection = source.CreateConnection();
using var destinationConnection = destination.CreateConnection();
sourceConnection.Open();
destinationConnection.Open();
using var transaction = destinationConnection.BeginTransaction("DATAFACTORY");
using var deleteCommand = destinationConnection.CreateCommand();
var deletions = tablePrescriptions
.Select(t => t.TableName())
.Reverse()
.Select(tableName => "DELETE FROM {0};".FormatInvariant(tableName));
deleteCommand.CommandText = string.Concat(deletions);
deleteCommand.Transaction = transaction;
_ = deleteCommand.ExecuteNonQuery();
var copyOptions = CreateCopyOptions(disableTriggers);
foreach (var tablePrescription in tablePrescriptions)
{
var tableName = tablePrescription.TableName();
var columnNames = tablePrescription.ColumnPrescriptions.Select(c => c.ColumnDescription.Name);
ExecuteSqlBulkCopy(transaction, sourceConnection, destinationConnection, copyOptions, tableName, columnNames);
}
if (dryRun)
{
transaction.Rollback();
}
else
{
transaction.Commit();
}
}
