How can define multiple KEY in EntityFrameWorkClass C#

Question

[Table("Table_UserImages")]
public class UserImage
{
     [Key, Column("UserID")]
     public Nullable<Guid> UserID { get; set; }
     [Key, Column("ImageID")]
     public Nullable<int> ImageID { get; set; }  
}

Both column are Primary key but model only accept one Key at a time,then how can i over come this? have any solution ? please share?

Arjan Einbu · Accepted Answer · 2011-09-02 05:32:02Z

4

I believe you're describing a composite key, that is a key composed of two or more columns.

To describe this in EF, you need to also define the column ordering for the keys. Like this:

[Table("Table_UserImages")]
public class UserImage
{
    [Key, Column("UserID", Order=0)]
    public Guid? UserID { get; set; }
    [Key, Column("ImageID", Order=1)]
    public int? ImageID { get; set; }  
}

answered Sep 2, 2011 at 5:32

Arjan Einbu

13.7k2 gold badges59 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can define multiple KEY in EntityFrameWorkClass C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related