确认连接字符串是否正确设置,并且没有被覆盖或重置。
向应用程序的配置文件appsettings.json中添加数据库连接字符串,例如:
"ConnectionStrings": {
"DefaultConnection": "Server=tcp:{server-name}.database.windows.net,1433;Initial Catalog={database-name};Persist Security Info=False;User ID={user-id};Password={password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
}
public void ConfigureServices(IServiceCollection services)
{
var connectionString = Configuration.GetConnectionString("DefaultConnection");
services.AddDbContext(options => options.UseSqlServer(connectionString));
//...
}
public class HomeController : Controller
{
private readonly ApplicationDbContext _dbContext;
public HomeController(ApplicationDbContext dbContext)
{
_dbContext = dbContext;
}
public IActionResult Index()
{
var users = _dbContext.Users.ToList();
return View(users);
}
}
注意: