EF4 代码优先 CTP5 多对一

发布于 2024-10-09 22:47:04 字数 757 浏览 3 评论 0原文

我一直在尝试让 EF4 CTP5 与现有数据库很好地配合，但在一些基本的映射问题上遇到了困难。

到目前为止我有两个模型类：

public class Job
{
    [Key, Column(Order = 0)]
    public int JobNumber { get; set; }
    [Key, Column(Order = 1)]
    public int VersionNumber { get; set; }

    public virtual User OwnedBy { get; set; }
}

并且

[Table("Usernames")]
public class User
{
    [Key]
    public string Username { get; set; }

    public string EmailAddress { get; set; }

    public bool IsAdministrator { get; set; }
}

我有我的 DbContext 类将它们公开为 IDbSet

我可以查询我的用户，但是一旦我将 OwnedBy 字段添加到 Job 类中，我就开始在所有 Job 测试中收到此错误：

列名“UserUsername”无效。

我希望它的行为像 NHibernate 的多对一，而我认为 EF4 将其视为复杂类型。这应该怎么做呢？

原文

I've been trying to get EF4 CTP5 to play nice with an existing database, but struggling with some basic mapping issues.

I have two model classes so far:

public class Job
{
    [Key, Column(Order = 0)]
    public int JobNumber { get; set; }
    [Key, Column(Order = 1)]
    public int VersionNumber { get; set; }

    public virtual User OwnedBy { get; set; }
}

and

[Table("Usernames")]
public class User
{
    [Key]
    public string Username { get; set; }

    public string EmailAddress { get; set; }

    public bool IsAdministrator { get; set; }
}

And I have my DbContext class exposing those as IDbSet

I can query my users, but as soon as I added the OwnedBy field to the Job class I began getting this error in all my tests for the Jobs:

Invalid column name 'UserUsername'.

I want this to behave like NHibernate's many-to-one, whereas I think EF4 is treating it as a complex type. How should this be done?

分享到QQ

分享到微博

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

发布评论

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

你不是我要的菜∠ 2024-10-16 22:47:05

UserUsername 是 EF Code First 在作业表中为外键选择的默认名称。显然，它与现有数据库中 Jobs 表中的 FK 列的名称不同。您需要覆盖此约定并更改 FK 的默认名称，以便它与您的数据库匹配。以下是使用 Fluent API 的实现方式：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Job>()
                .HasOptional(j => j.OwnedBy)
                .WithMany()
                .IsIndependent()
                .Map(m => m.MapKey(u => u.Username, "TheFKNameInYourDB"));
}

UserUsername is the default name that EF Code First chooses for the foreign key in the Jobs table. Obviously, it's not the same name that your existing database has for the FK column in Jobs table. You need to override this conventions and change the FK's default name so that it matches your database. Here is how it's done with fluent API:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Job>()
                .HasOptional(j => j.OwnedBy)
                .WithMany()
                .IsIndependent()
                .Map(m => m.MapKey(u => u.Username, "TheFKNameInYourDB"));
}

回复收藏 0 原文