ASP.NET Core 6 数据库保存报错：找不到VehiclePerson表

报错信息 #

SqlException: Invalid object name 'VehiclePerson'.

背景 #

正在学习ASP.NET Core 6，向数据库保存记录时遇到上述错误。已确认数据库连接正常，且通过Scaffolding从Microsoft SSMS生成了数据库模型和Context文件。

相关代码 #

VehiclePerson.cs实体类 #

using System.Collections.Generic;

namespace APITDCON.Models.QQGUAR01;

public partial class VehiclePerson
{
    public string? EmpNumber { get; set; }
    public string? Lastname { get; set; }
    public string? Firstname { get; set; }
    public string? Costcenter { get; set; }
    public string? Department { get; set; }
    public string? CredentNumber { get; set; }
    public string? FromDate { get; set; }
    public string? ToDate { get; set; }
    public string? Rights { get; set; }
    public int Id { get; set; }
}

上下文类APITDCONContext.cs #

using Microsoft.EntityFrameworkCore;
using APITDCON.Models.QQGUAR01;
using Microsoft.IdentityModel.Tokens;
using System.Reflection;
using System;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
namespace APITDCON.Data
{
    public class APITDCONContext : DbContext
    {
        public APITDCONContext(DbContextOptions<APITDCONContext> options) : base(options) 
        {
            

        }
        public DbSet<VehiclePerson> VehiclePerson { get; set; }
    }
}

控制器VehiclePersonController1.cs #

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using APITDCON.Models.TANKFARM;
using APITDCON.Models;
using APITDCON.Data;
using System.Collections;



namespace APITDCON.Controllers
{

    public class VehiclePersonController1 : Controller
    {
        private readonly APITDCONContext _apiTDCONContext;
        public VehiclePersonController1(APITDCONContext apiTDCONContext)
        {
            _apiTDCONContext = apiTDCONContext;
        }

        [HttpGet]
        public async Task<IActionResult> Index() 
        {
            List<VehiclePerson> lista = new List<VehiclePerson>();
            lista = GetAllDataDrivers();
            return View(lista);
        }

        [HttpGet]
        public IActionResult Add()
        {
            return View();
        }

        [HttpPost]
        public IActionResult Add(VehiclePerson vehiclePersonRequest)
        {
            string mensaje = "";
            var vehicleperson = new VehiclePerson()
            {
                EmpNumber = vehiclePersonRequest.EmpNumber,
                Lastname = vehiclePersonRequest.Lastname,
                Firstname = vehiclePersonRequest.Firstname,
                Costcenter = vehiclePersonRequest.Costcenter,
                Department = vehiclePersonRequest.Department,
                CredentNumber = vehiclePersonRequest.CredentNumber,
                FromDate = vehiclePersonRequest.FromDate,
                ToDate = vehiclePersonRequest.ToDate,
                Rights = vehiclePersonRequest.Rights
            };

            using (var db = new Models.QQGUAR01.Qqguar01Context())
            {
                var result = new List<VehiclePerson>();
                result = (from data in db.VehiclePerson
                          select new VehiclePerson
                         {
                             EmpNumber = data.EmpNumber,
                             Lastname = data.Lastname,
                             Firstname = data.Firstname
                         }).ToList();
            }

            _apiTDCONContext.VehiclePerson.Add(vehicleperson);
            _apiTDCONContext.SaveChanges();
            return RedirectToAction("Add");
        }
    }
}

补充信息 #

• 数据库表截图：
• 报错截图：

从代码和截图来看，核心问题是EF Core映射的表名与实际数据库表名不匹配。数据库截图显示实际表名为VEHICLE_PERSON（下划线分隔），但EF默认会将DbSet<VehiclePerson>映射为VehiclePerson（帕斯卡命名），导致找不到对应表。

可通过以下两种方式解决：

1. 给实体类添加表名特性
   在VehiclePerson类上引入System.ComponentModel.DataAnnotations.Schema命名空间，添加[Table]特性指定实际表名：

using System.ComponentModel.DataAnnotations.Schema;

namespace APITDCON.Models.QQGUAR01;

[Table("VEHICLE_PERSON")]
public partial class VehiclePerson
{
    // 原有属性保持不变
}

2. 在上下文类中配置表映射
   在APITDCONContext中重写OnModelCreating方法，手动配置表名映射：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<VehiclePerson>().ToTable("VEHICLE_PERSON");
}

另外注意：你在Post方法中同时使用了APITDCONContext和Qqguar01Context，需确认两个上下文的连接字符串指向同一数据库，避免因上下文混用导致额外问题。

配置完成后执行SaveChanges()，EF会使用正确的表名生成SQL，即可解决找不到表的错误。

内容的提问来源于stack exchange，提问作者Leonardo Carrasco Velazquez