DbUp希望运行以前运行的脚本

Question

             IConfiguration config = new ConfigurationBuilder()
                .AddJsonFile("appsettings.json")
                .AddJsonFile("appsettings.Development.json", true)
                .AddEnvironmentVariables() // Overwrite with any environment variables, e.g., from Azure environments.
                .Build();

           var upgrader =
                DeployChanges.To
                    .SqlDatabase(connectionString)
                    .WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly(), s => !s.Contains(TestDataScriptsFolderName), 
                    new DbUp.Engine.SqlScriptOptions
                    {
                        ScriptType = DbUp.Support.ScriptType.RunOnce,
                        RunGroupOrder = 1
                    })
                    .LogToConsole();

            if (args.Any(a => a.Contains("IncludeTestData")) || config.GetValue<bool>("IncludeTestData"))
            {
                Console.WriteLine("Test data scripts will be executed as part of the upgrade.");

                upgrader.WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly(), s => s.Contains(TestDataScriptsFolderName),
                    new DbUp.Engine.SqlScriptOptions
                    {
                        //ScriptType = DbUp.Support.ScriptType.RunAlways, 
                        RunGroupOrder = 2
                    })
                    .LogToConsole();
            }

            DbUp.Engine.UpgradeEngine u = upgrader.Build();

            List<DbUp.Engine.SqlScript> allScripts = u.GetDiscoveredScripts();
            // 52 -- all of them

            List<string> executedScripts = u.GetExecutedScripts();
            // 543 -- because the test data scripts (which are idempotent) were run at every deployment.

            List<DbUp.Engine.SqlScript> todoScripts = u.GetScriptsToExecute();
            // All 52! It should be 0 because all scripts have been run.

            bool ug = u.IsUpgradeRequired();

            Console.WriteLine(allScripts.Any(z => z.Name.EndsWith("T20200518T1023_InitialTestData.sql")));
            Console.WriteLine(executedScripts.Any(z => z.EndsWith("T20200518T1023_InitialTestData.sql")));
            Console.WriteLine(todoScripts.Any(z => z.Name.EndsWith("T20200518T1023_InitialTestData.sql")));

            var result = upgrader.Build().PerformUpgrade();

如前所述，GetScriptsToExecute应该返回一个空数组，因为所有脚本都已经运行--并且列在SchemaVersions表中。但它会把所有的剧本都还回去。为什么？

Answer 1

问题是，csproj的命名空间已经更改，并且它在SchemaVersions表中的脚本名称中占优势，这三个名称与重命名的项目中的脚本名称不匹配。