public Startup(IWebHostEnvironment env)
{
var builder = new ConfigurationBuilder()
.SetBasePath(env.ContentRootPath)
.AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
.AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true)
.AddJsonFile("secrets.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables();
Configuration = builder.Build();
}
public void ConfigureServices(IServiceCollection services)
{
services.AddDbContext(options =>
options.UseSqlServer(Configuration.GetConnectionString("MyConnectionString")));
}
{
"ConnectionStrings": {
"MyConnectionString": "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"
}
}
其中,MyConnectionString是数据库连接字符串的名称,myServerAddress是SQL Server数据库服务器的地址,myDataBase是数据库名称,myUsername是登录数据库的用户名,myPassword是登录数据库的密码。 4. 运行应用程序并检查连接字符串是否正确。