与导航属性同名的列没有 ID 的外键

发布于 2025-01-18 21:27:28 字数 687 浏览 0 评论 0原文

我有以下表格。

CREATE TABLE Thing
(
    Id INT PRIMARY KEY IDENTITY(1, 1),
    CreatedByUser INT NOT NULL
)
 
CREATE TABLE User
(
    Id INT PRIMARY KEY IDENTITY(1, 1)
)

我有以下 EF 实体，（有意）使用不带 Id 的导航属性进行定义。

public class Thing
{
    public int Id { get; set; }
 
    public User CreatedByUser { get; set; }
}
 
public class User
{
    public int Id { get; set; }
}

我想知道当表上的基础 Id 字段与我想要包含在实体模型中的导航属性同名时如何定义外键关系。 以下示例无法找到名为 CreatedByUser_Id 的数据库列。

modelBuilder.Entity<Thing>()
  .HasOne(x => x.CreatedByUser)
  .WithMany()
  .HasForeignKey("CreatedByUser_Id")
  .IsRequired();

谢谢

原文

I have the following tables.

CREATE TABLE Thing
(
    Id INT PRIMARY KEY IDENTITY(1, 1),
    CreatedByUser INT NOT NULL
)
 
CREATE TABLE User
(
    Id INT PRIMARY KEY IDENTITY(1, 1)
)

I have the following EF entities, defined (intentionally) with a navigational property without an Id.

public class Thing
{
    public int Id { get; set; }
 
    public User CreatedByUser { get; set; }
}
 
public class User
{
    public int Id { get; set; }
}

I would like to know how to define the foreign key relationship when the underlying Id field on the table is the same name as the navigation property I would like include on the entity model. The following example fails to find a db column with the name CreatedByUser_Id.

modelBuilder.Entity<Thing>()
  .HasOne(x => x.CreatedByUser)
  .WithMany()
  .HasForeignKey("CreatedByUser_Id")
  .IsRequired();

Thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

宫墨修音 2025-01-25 21:27:28

用以下内容修复了它。

modelBuilder.Entity<Thing>()
    .HasOne(x => x.CreatedByUser)
    .WithMany()
    .HasForeignKey("CreatedByUser_Id")
    .IsRequired();

modelBuilder.Entity<Thing>()
    .Property("CreatedByUser_Id")
    .HasColumnName("CreatedByUser");

Fixed it with the following.

modelBuilder.Entity<Thing>()
    .HasOne(x => x.CreatedByUser)
    .WithMany()
    .HasForeignKey("CreatedByUser_Id")
    .IsRequired();

modelBuilder.Entity<Thing>()
    .Property("CreatedByUser_Id")
    .HasColumnName("CreatedByUser");

回复收藏 0 原文

~没有更多了~