调试ASP.NET Core项目遇连接字符串未初始化错误求助

System.InvalidOperationException: 'The ConnectionString property has not been initialized.' 错误的核心原因是数据库连接字符串未被正确注入到数据访问组件中，导致AirportService无法正常执行数据库查询，前端通过API请求时收到错误响应，进而弹出“获取机场列表时出错”的提示。以下是针对各文件的排查和修复方案：

1. 检查appsettings.json的连接字符串配置 #

确保配置文件中存在格式正确的ConnectionStrings节点，替换为你的实际数据库连接信息：

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=你的数据库地址;Database=目标数据库名;Trusted_Connection=True;TrustServerCertificate=True;"
  }
}

2. 修正Program.cs的服务注册逻辑 #

确保配置被正确读取，且服务依赖注入配置正确：

若使用EF Core： #

var builder = WebApplication.CreateBuilder(args);

// 读取连接字符串
var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");
// 注册DbContext
builder.Services.AddDbContext<YourDbContext>(options =>
    options.UseSqlServer(connectionString));

// 注册AirportService（推荐使用接口+实现的方式）
builder.Services.AddScoped<IAirportService, AirportService>();

// 其他中间件配置...
var app = builder.Build();

若直接使用SqlConnection： #

builder.Services.AddScoped<AirportService>(sp => 
{
    var config = sp.GetRequiredService<IConfiguration>();
    var connString = config.GetConnectionString("DefaultConnection") 
        ?? throw new InvalidOperationException("未找到数据库连接字符串");
    return new AirportService(connString);
});

3. 修复AirportService.cs的连接字符串初始化 #

确保服务通过构造函数正确接收并使用连接字符串：

直接使用SqlConnection的正确示例： #

public class AirportService
{
    private readonly string _connectionString;

    // 构造函数注入连接字符串
    public AirportService(string connectionString)
    {
        _connectionString = connectionString ?? throw new ArgumentNullException(nameof(connectionString));
    }

    public async Task<List<Airport>> GetAirports()
    {
        var airports = new List<Airport>();
        using var connection = new SqlConnection(_connectionString);
        await connection.OpenAsync();
        
        // 执行查询逻辑（示例）
        var command = new SqlCommand("SELECT * FROM Airports", connection);
        using var reader = await command.ExecuteReaderAsync();
        while (await reader.ReadAsync())
        {
            airports.Add(new Airport
            {
                Id = reader.GetInt32(0),
                Name = reader.GetString(1)
                // 映射其他字段
            });
        }
        return airports;
    }
}

使用EF Core的正确示例： #

public class AirportService
{
    private readonly YourDbContext _dbContext;

    public AirportService(YourDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public async Task<List<Airport>> GetAirports()
    {
        return await _dbContext.Airports.ToListAsync();
    }
}

4. 验证AirportController.cs的API端点 #

确保控制器正确注入服务并处理异常：

[ApiController]
[Route("api/[controller]")]
public class AirportController : ControllerBase
{
    private readonly IAirportService _airportService;

    public AirportController(IAirportService airportService)
    {
        _airportService = airportService;
    }

    [HttpGet]
    public async Task<IActionResult> GetAirports()
    {
        try
        {
            var airports = await _airportService.GetAirports();
            return Ok(airports);
        }
        catch (Exception ex)
        {
            // 可添加日志记录，返回明确的错误信息
            return StatusCode(500, new { Message = "获取机场列表时出错", Detail = ex.Message });
        }
    }
}

5. 检查site.js的请求逻辑 #

确保前端请求的API地址与后端路由匹配，错误处理逻辑正确：

function loadAirportList() {
    $.ajax({
        url: '/api/Airport', // 与Controller的Route配置一致
        type: 'GET',
        success: function(data) {
            // 渲染机场列表的逻辑
            renderAirportList(data);
        },
        error: function(xhr) {
            var errorMsg = xhr.responseJSON?.Message || "请求失败，请检查后端服务";
            alert(`获取机场列表时出错: ${errorMsg}`);
        }
    });
}

验证步骤 #

1. 重启项目，确保appsettings.json的配置被正确加载
2. 打开浏览器开发者工具（F12），查看Network标签，确认请求的状态码和响应内容
3. 若仍有错误，查看后端日志（可在Program.cs中添加日志配置）定位具体异常

内容的提问来源于stack exchange，提问作者Khánh Huyền Phan