ASP.NET Core EF Core更新数据库报错：Host can't be null

我新建了一个ASP.NET Core Web API项目，正在配置Entity Framework Core。已完成初始迁移，Migrations文件夹成功生成迁移类，但执行dotnet ef database update命令时失败，报错信息如下：

dotnet ef database update
Build started...
Build succeeded.

System.ArgumentException: Host can't be null
at Npgsql.NpgsqlConnectionStringBuilder.PostProcessAndValidate()
at Npgsql.NpgsqlConnection.SetupDataSource()
at Npgsql.NpgsqlConnection.set_ConnectionString(String value)
at Npgsql.NpgsqlConnection..ctor(String connectionString)
at Npgsql.NpgsqlConnection.CloneWith(String connectionString)
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlRelationalConnection.CloneWith(String connectionString)
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists(Boolean async, CancellationToken cancellationToken)
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists()
at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.GetAppliedMigrations()
at Npgsql.EntityFrameworkCore.PostgreSQL.Migrations.Internal.NpgsqlMigrator.Migrate(String targetMigration)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)

Host can't be null

项目相关代码 #

Program.cs #

using Microsoft.EntityFrameworkCore;
using ShopBack.Services;
    
var builder = WebApplication.CreateBuilder(args);

builder.Services
       .AddScoped<ProductsService>()  
       .AddControllers(options => options.SuppressAsyncSuffixInActionNames = false);
        
builder.Services.AddDbContext<LibraryContext>(options =>
        {
            options.UseNpgsql(builder.Configuration.GetConnectionString("YourConnectionName"));
        });
    
var app = builder.Build();

// configure request pipeline
app.MapControllers();
    
app.UseCors (x => x
            .AllowAnyOrigin()
            .AllowAnyMethod()
            .AllowAnyHeader());
    
app.Run();

appsettings.json #

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "YourConnectionName": "Host=127.0.0.1; Port=5432; User Id=postgres; Password=postgres; Database=shopback"
  }
}

appsettings.Development.json #

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "YourConnectionName": "Host=127.0.0.1; Port=5432; User Id=postgres; Password=postgres; Database=shopback"
  }
}

.csproj #

<Project Sdk="Microsoft.NET.Sdk.Web">

  <PropertyGroup>
    <TargetFramework>net8.0</TargetFramework>
    <Nullable>enable</Nullable>
    <ImplicitUsings>enable</ImplicitUsings>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="8.0.7">
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
      <PrivateAssets>all</PrivateAssets>
    </PackageReference>

    <PackageReference Include="Npgsql" Version="8.0.3" />

    <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.4" />

  </ItemGroup>

  <ItemGroup>
    <None Update="appsettings.json">
      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
    </None>
  </ItemGroup>

</Project>

解决方案 #

1. 确认命令执行目录 #

执行dotnet ef database update时，终端工作目录必须是**.csproj文件所在的项目根目录**，不能是Migrations等子文件夹。否则EF Core无法正确读取配置文件，导致连接字符串为空。

2. 显式指定环境变量 #

尝试在命令中指定开发环境，确保加载appsettings.Development.json的配置：

dotnet ef database update --environment Development

3. 验证连接字符串读取 #

在Program.cs中临时添加日志输出，确认连接字符串是否被正确读取：

var connString = builder.Configuration.GetConnectionString("YourConnectionName");
Console.WriteLine($"读取到的连接字符串：{connString}");

运行项目或执行迁移前，检查控制台输出是否显示完整的连接字符串。如果输出为空，需排查：

• appsettings.json是否被复制到输出目录（当前.csproj已设置CopyToOutputDirectory，可检查bin目录下是否存在该文件）
• JSON格式是否正确，有无语法错误（比如逗号遗漏、引号不匹配）

4. 统一Npgsql包版本 #

当前项目中Npgsql（8.0.3）与Npgsql.EntityFrameworkCore.PostgreSQL（8.0.4）版本不一致，可能存在兼容性问题。建议升级到相同的稳定版本：

<PackageReference Include="Npgsql" Version="8.0.7" />
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.7" />

更新后执行dotnet restore，再尝试迁移命令。

5. 直接传入连接字符串测试 #

若以上方法无效，可直接在命令中指定连接字符串，绕开配置文件读取：

dotnet ef database update --connection "Host=127.0.0.1; Port=5432; User Id=postgres; Password=postgres; Database=shopback"

如果此命令成功，说明问题出在配置文件读取环节，需进一步排查配置加载逻辑。

内容的提问来源于stack exchange，提问作者David Pugh