Sample code for a migration test using C# and MigratorDotNet for an ASP.NET MVC 2 web app

FullMigrationTest.cs

namespace UnitTests
{
    public class FullMigrationTest
    {
        public static string[] AllExpectedTables = new[]
                                  {
                                      "BlogPost",
                                      "Attachment",
                                      "Photo",

                                      // aspnet auth stuff:
                                      "aspnet_Applications",
                                      "aspnet_Membership",
                                      "aspnet_Profile",
                                      "aspnet_Roles",
                                      "aspnet_SchemaVersions",
                                      "aspnet_Users",
                                      "aspnet_UsersInRoles",
                                      "SchemaInfo",
                                  };

        [Test]
        public void all_migrations_should_run_successfully()
        {
            MigrationTestHelper.MigrateAllTheWayDown();
            MigrationTestHelper.MigrateAllTheWayUp();

            var tablesInDatabase = GetTablesInDatabase();

            Want(tablesInDatabase).ToHaveSameItemsAs(AllExpectedTables);
        }
    }
}