How to add two different properties of the same class to one POCO class?

Question

I have a class that has two references to one class (User):

public class Xpto {
    public string Username { get; set; }
    public virtual User User { get; set; }
    public string Username2 { get; set; }
    public virtual User User2 { get; set; }
}

The thing is EF only creates references to the first key (Username). That way User and User2 have Username as key and not what I intended...

I found this to be the answer:

nHibernate, mapping two properties to the same class

But I wouldn't know how to apply this to my scenario.

Thanks.

EDIT: Folks, nevermind... I guess I should've looked a little further. The answer is here: How do I create a POCO object that has 2 references to another class

The standard is <property_name><key_name> So the correct way would be UserUsername and User2Username

Thanks.

Could you post the User class, please? – Daniel Persson Oct 27 '12 at 22:41 — Daniel Persson, Oct 27 '12 at 22:41
@DanielPersson It's a standard class with Username as [Key] – eestein Oct 27 '12 at 22:43 — eestein, Oct 27 '12 at 22:43

score 1 · Accepted Answer · answered Oct 27 '12 at 22:52

1

Consider using the ForeignKeyAttribute instead, then you can select the names you like for your key attributes.

public class Xpto {

    [ForeignKey("User")]
    public string Username { get; set; }

    public virtual User User { get; set; }

    [ForeignKey("User2")]
    public string Username2 { get; set; }

    public virtual User User2 { get; set; }
}

answered Oct 27 '12 at 22:52

Daniel Persson

2,171
1
17
24

I found... System.ComponentModel.DataAnnotations.Schema Thanks, I'll do that way – eestein Oct 27 '12 at 23:00

How to add two different properties of the same class to one POCO class?

1 Answers1