public async Task InstallMigrationsTestAsync()
        {
            DeleteDatabase();

            var resourceAssm = Assembly.GetExecutingAssembly();
            var mig          = new LiteMigration(TempDatabasePath, resourceAssm, _baseNamespace);

            var allMigs = mig.Migrations.GetSortedMigrations();
            var missing = await mig.GetMissingMigrationsAsync();

            Assert.IsTrue(allMigs.Count > 0);
            Assert.IsNotNull(missing);
            Assert.AreEqual(allMigs.Count, missing.Count);

            // Act
            bool success = await mig.MigrateUpAsync();

            // Assert
            Assert.IsTrue(success, mig.LastError);
            missing = await mig.GetMissingMigrationsAsync();

            Assert.AreEqual(0, missing.Count);
        }
        public async Task AllMigrationsAreNotInstalledTestAsync()
        {
            // Get not installed scripts.
            // returns sorted list of IMigration with namespace path to resource
            ClearVersionInfo();

            var resourceAssm = Assembly.GetExecutingAssembly();
            var mig          = new LiteMigration(TempDatabasePath, resourceAssm, _baseNamespace);

            var allMigs = mig.Migrations.GetSortedMigrations();
            var missing = await mig.GetMissingMigrationsAsync();

            Assert.IsTrue(allMigs.Count > 0);
            Assert.IsNotNull(missing);
            Assert.AreEqual(allMigs.Count, missing.Count);
        }