public void Drop_Foreign_Key()
{
// Arrange
var context = new MigrationContext(DatabaseProviders.SqlServerCE, null, Mock.Of <ILogger>());
var stub = new DropForeignKeyMigrationStub(new SqlCeSyntaxProvider(), Mock.Of <ILogger>());
// Act
stub.GetUpExpressions(context);
// Assert
Assert.That(context.Expressions.Count(), Is.EqualTo(1));
Assert.That(context.Expressions.Single().ToString(), Is.EqualTo("ALTER TABLE [umbracoUser2app] DROP CONSTRAINT [FK_umbracoUser2app_umbracoUser_id]"));
}
public void Drop_Foreign_Key()
{
// Arrange
var database = new TestDatabase();
var context = new MigrationContext(database, _logger);
var stub = new DropForeignKeyMigrationStub(context);
// Act
stub.Migrate();
foreach (var op in database.Operations)
{
Console.WriteLine("{0}\r\n\t{1}", op.Text, op.Sql);
}
// Assert
Assert.That(database.Operations.Count, Is.EqualTo(1));
Assert.That(database.Operations[0].Sql, Is.EqualTo("ALTER TABLE [umbracoUser2app] DROP CONSTRAINT [FK_umbracoUser2app_umbracoUser_id]"));
}