如何在Entity Framework中添加关联数据？代码无法保存数据求助

一、排查数据无法保存的原因及修复 #

1. 补充模型必填验证 #

你的Equipment模型中DepartmentId未标记为必填，若数据库中该字段是外键且非空，会导致保存时触发约束错误。给DepartmentId添加[Required]特性：

public class Equipment
{
    [Key]
    public int Id { get; set; }

    [Required]
    [DisplayName("Equipment Name")]
    public string Name { get; set; }

    [Required]
    public int Amount { get; set; }

    [Required]
    public string Status { get; set; }

    // 添加Required特性，确保前端必须选择部门
    [Required]
    public int DepartmentId { get; set; }
    public Department Department { get; set; }
}

2. 捕获保存异常排查具体错误 #

在POST的Create方法中添加异常捕获，明确保存失败的原因（比如外键不存在、字段约束冲突等）：

// POST: Equipment/Create
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("Id,Name,Amount,Status,DepartmentId")] Equipment equipment)
{
    if (ModelState.IsValid)
    {
        try
        {
            _context.Add(equipment);
            await _context.SaveChangesAsync();
            return RedirectToAction(nameof(Index));
        }
        catch (DbUpdateException ex)
        {
            // 把具体错误添加到ModelState，前端会显示
            ModelState.AddModelError(string.Empty, $"保存失败：{ex.InnerException?.Message ?? ex.Message}");
        }
    }
    ViewData["DepartmentId"] = new SelectList(_context.Departments, "Id", "Name", equipment.DepartmentId);
    return View(equipment);
}

3. 确保下拉框绑定正常 #

检查_context.Departments是否有数据，若为空，下拉框没有可选部门，导致提交的DepartmentId为0（int默认值），而数据库中不存在Id为0的部门，触发外键错误。可以在GET的Create方法中判断：

// GET: Equipment/Create
public IActionResult Create()
{
    var departments = _context.Departments.ToList();
    if (!departments.Any())
    {
        ModelState.AddModelError(string.Empty, "请先添加部门数据");
    }
    ViewData["DepartmentId"] = new SelectList(departments, "Id", "Name");
    return View();
}

二、显示Equipment对应的部门名称 #

要显示设备所属部门名称，需要确保EF加载Department关联数据，有两种方式：

1. 预加载关联数据（推荐） #

在查询设备列表时，使用Include方法显式加载关联的Department，比如在Index方法中：

public async Task<IActionResult> Index()
{
    // Include预加载Department数据
    var equipments = await _context.Equipments.Include(e => e.Department).ToListAsync();
    return View(equipments);
}

然后在Index视图中直接访问部门名称：

@model IEnumerable<Equipment>

<table class="table">
    <thead>
        <tr>
            <th>@Html.DisplayNameFor(model => model.Name)</th>
            <th>@Html.DisplayNameFor(model => model.Amount)</th>
            <th>@Html.DisplayNameFor(model => model.Status)</th>
            <th>@Html.DisplayNameFor(model => model.Department.Name)</th>
            <th></th>
        </tr>
    </thead>
    <tbody>
@foreach (var item in Model) {
        <tr>
            <td>@Html.DisplayFor(modelItem => item.Name)</td>
            <td>@Html.DisplayFor(modelItem => item.Amount)</td>
            <td>@Html.DisplayFor(modelItem => item.Status)</td>
            <td>@item.Department.Name</td>
            <td>
                <a asp-action="Edit" asp-route-id="@item.Id">Edit</a> |
                <a asp-action="Details" asp-route-id="@item.Id">Details</a> |
                <a asp-action="Delete" asp-route-id="@item.Id">Delete</a>
            </td>
        </tr>
}
    </tbody>
</table>

2. 启用懒加载（可选） #

给Equipment的Department属性添加virtual关键字，同时确保EF Core启用了懒加载（需安装Microsoft.EntityFrameworkCore.Proxies包）：

public virtual Department Department { get; set; }

在DbContext的OnConfiguring方法中启用懒加载：

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    optionsBuilder.UseLazyLoadingProxies()
                  .UseSqlServer("你的连接字符串");
}

之后在视图中同样可以直接访问@item.Department.Name，EF会自动在访问时加载关联数据。

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