Blazor中Security与Portfolio实体绑定失败问题求助

1. 修正Security实体的外键配置 #

当前Security实体缺少明确的外键属性，EF Core无法正确识别与Portfolio的关联关系，且未标记Portfolio关联为必填。修改实体代码：

public class Security
{
    [Key]
    public int Id { get; set; }
    [Required]
    public string SecurityName { get; set; } = string.Empty;
    [Required]
    public float Price { get; set; }
    [Required]
    // 修正拼写错误：StockesOwned → StocksOwned
    public int StocksOwned { get; set; } = 0;
    [Required]
    public float StocksValue { get; set; }
    public DateTime DateTimeObtained { get; set; } = DateTime.UtcNow;
    public string? Description { get; set; } = string.Empty;
    
    // 添加必填外键属性，关联Portfolio的主键
    [Required]
    public int PortfolioId { get; set; }
    
    // 配置导航属性与外键的关联
    [ForeignKey(nameof(PortfolioId))]
    public Portfolio Portfolio { get; set; }
}

2. 修复Blazor前端下拉框绑定错误 #

前端下拉框的绑定逻辑错误，应绑定Security的PortfolioId属性（而非直接绑定Portfolio对象），修改代码：

<div class="row w-100">
    <div class="col-6">
        Portfolio
    </div>
    <div class="col-md-4">
        <!-- 绑定到Security的PortfolioId属性 -->
        <select class="form-control" @bind="@Security.PortfolioId">
            <option value="">Select Portfolio</option>
            @foreach (var portfolio in Portfolios)
            {
                <option value="@portfolio.PortfolioId">@portfolio.NameOfPortfolio</option>
            }
        </select>
        <!-- 添加验证提示，未选择时显示错误 -->
        <ValidationMessage For="@(() => Security.PortfolioId)" />
    </div>
</div>

同时确保组件内正确初始化Security对象和加载Portfolio列表：

@code {
    private Security Security { get; set; } = new Security();
    private List<Portfolio> Portfolios { get; set; } = new List<Portfolio>();

    protected override async Task OnInitializedAsync()
    {
        // 调用API获取所有Portfolio数据
        Portfolios = await _portfolioService.GetAllPortfoliosAsync();
    }
}

3. 完善服务端模型验证（可选但推荐） #

控制器中添加模型状态检查，明确返回验证错误信息，便于调试：

[HttpPost]
public async Task<ActionResult<ServiceResponse<int>>> CreateSecurity(Security security)
{
    if (!ModelState.IsValid)
    {
        var errorMessages = string.Join("; ", ModelState.Values
            .SelectMany(v => v.Errors.Select(e => e.ErrorMessage)));
        return BadRequest(new ServiceResponse<int>
        {
            Success = false,
            Message = errorMessages
        });
    }
    var result = await _securityService.CreateSecurityAsync(security);
    return Ok(result);
}

4. 验证提交逻辑 #

客户端提交时，Security对象的PortfolioId会被正确赋值为选中的Portfolio主键，EF Core会自动通过外键关联对应的Portfolio实体，无需传递完整的Portfolio对象。服务端的CreateSecurityAsync方法无需修改，直接添加Security即可。

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