private void GetAndDropConstraints()
{
#if PocketPC
#else
if (_disableConstraints)
{
var fkRepo = new ForeignKeyRepository(_conn.ConnectionString, _destination);
_savedConstraints = fkRepo.GetConstraints();
fkRepo.DropConstraints();
}
#endif
}
public void Test_DisableConstraints_Enabled_Timing()
{
var connString = GetChinookConnectionString();
using (var bc = new SqlCeBulkCopy(connString, SqlCeBulkCopyOptions.DisableConstraints))
{
bc.DestinationTableName = "InvoiceLine";
var sw = new Stopwatch();
sw.Start();
bc.WriteToServer(GetTestInvoiceLineTable(connString));
sw.Stop();
Debug.WriteLine("Without constraints: " + sw.ElapsedMilliseconds);
var fkRepo = new ForeignKeyRepository(connString, "InvoiceLine");
var savedConstraints = fkRepo.GetConstraints();
Assert.IsTrue(savedConstraints.Count == 2);
}
}
private void RestoreConstraints()
{
#if PocketPC
#else
var fkRepo = new ForeignKeyRepository(_conn.ConnectionString, _destination);
try
{
if (_disableConstraints)
{
fkRepo.AddConstraints(_savedConstraints);
}
}
catch (SqlCeException ex)
{
throw new Exception(ex.Message + Environment.NewLine + fkRepo.GetAddConstraintStatements(_savedConstraints), ex);
}
#endif
}
