我有一個用于比較我們的 SQL Server 資料庫的 blazor 應用程式。
在appsettings.json ，我試圖設定：
"AllowedHosts": "*",
"ConnectionStrings": {
"SourceConnectionString": "Server=tcp:myserver.database.windows.net,1433;Initial Catalog=prod;Persist Security Info=False;User [email protected];Password=123;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Password';",
"TargetConnectionString": "Server=tcp:myserver.database.windows.net,1433;Initial Catalog=dev;Persist Security Info=False;User [email protected];Password=123;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Password';"
}
注意：SourceConnectionString和TargetConnectionString用于不同.cs的如下：
namespace MsSQLDatabaseComparison.DbContexts;
public class SourceDbContext
{
private readonly IConfiguration _configuration;
private readonly string _connectionString;
public SourceDbContext(IConfiguration configuration)
{
_configuration = configuration;
_connectionString = _configuration.GetConnectionString("SourceConnectionString");
}
public IDbConnection CreateConnection() => new SqlConnection(_connectionString);
}
namespace MsSQLDatabaseComparison.DbContexts;
public class TargetDbContext
{
private readonly IConfiguration _configuration;
private readonly string _connectionString;
public TargetDbContext(IConfiguration configuration)
{
_configuration = configuration;
_connectionString = _configuration.GetConnectionString("TargetConnectionString");
}
public IDbConnection CreateConnection() => new SqlConnection(_connectionString);
}
然后我得到了錯誤：
關于如何修復與 SQL Server 的連接的任何建議都非常感謝？
uj5u.com熱心網友回復：
弄清楚了
using SqlConnection = Microsoft.Data.SqlClient.SqlConnection;
非常感謝@Daniel Mann 和@AlwaysLearning 指出這一點
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/527212.html