开发者

Can you use navigation sub-properties in foreign keys using EF 4.1 fluent API?

开发者 https://www.devze.com 2023-03-07 12:50 出处:网络
Let\'s use a simple example: public class Employee { public int EmployeeID { get; set; } public ICollection<Pay> Pays { get; set; }

Let's use a simple example:

public class Employee
{
    public int EmployeeID { get; set; }
    public ICollection<Pay> Pays { get; set; }
}

public class Pay
{
    public Employee Employee { get; set; }
    public int Year { get; set; }
    public double Amount { get; set; }
}

Is there any way to use the fluent API to create a Pays table with a primary key on Employee_EmployeeID, Year (using EF4.1 column conventions)?

I don't want to use data annotations but I tried this anyway:

public class Pay
{
    [Key, Column(Order = 0)]
    public Employee Employee { get; set; }
    [Key, Column(Order = 1)]
    public int Year { get; set; }
    public double Amount { get; set; }
}

All that got me was a primary key on Year 开发者_开发问答and a foreign key on Employee_EmployeeID though.


This will be only possible if you also add FK property to your Pay:

public class Pay
{
    public int EmployeeId { get; set; }
    public Employee Employee { get; set; }
    public int Year { get; set; }
    public double Amount { get; set; }
}

Now you can map it with fluent-api:

modelBuilder.Entity<Pay>()
            .HasKey(p => new 
                {
                    p.EmployeeId,
                    p.Year
                });

You need employee's FK as a property if you want to make it part of PK.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号