c# - EF Code First 数据库迁移中的 DbMigrator 需要访问主数据库

Question

我使用以下代码来检查是否有任何待处理的 EF DB 迁移。

var dbConnectionInfo = new DbConnectionInfo(dbConnectionString, "System.Data.SqlClient");
var migratorConfig = new Configuration
{
    TargetDatabase = dbConnectionInfo
};
var dbMigrator = new DbMigrator(migratorConfig);
// the following line throws SqlException when run against SQL Server in Azure
var pendingMigrations = dbMigrator.GetPendingMigrations().ToList();
var pendingMigrationsCount = pendingMigrations.Count;

当我对 Azure 中的 SQL 数据库使用它时，它失败了。 请注意，无法在 Azure 的 SQL Server 版本中为 sql 用户分配默认数据库。

有解决办法或解决方法吗？

异常(exception):

The server principal "O-someuser" is not able to access the database "master" under the current security context. Database 'master' on server 'xyz.westus1-a.worker.database.windows.net' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of 'blah blah'.

Answer 1

如果我们可以连接到 Azure SQL 服务器。请尝试创建一个新的登录名来尝试一下。它对我来说工作正常。详细信息请引用截图。

The default admin user is also worked for me.