devlife
Reputation: 16155
Entity Framework foreign keys to non-primary key fields
Is it possible for Entity Framework 4.0 to have an association/navigation property based off of a foreign key to a non-primary key field (it has a unique constraint).
Upvotes: 13
Views: 5223
Answers (1)
Ladislav Mrnka
Reputation: 364409
No because EF don't understand unique constraint yet and relations in EF must follow same rules as relations in database. Without unique principal relation cannot exist and the only way to get unique principal in EF is using primary key.
Upvotes: 9
Related Questions
- Entity Framework 6.1.3 Mapping Foreign key to non primary key
- Entity Framework Core: use auto-generated foreign key as part of composite primary key
- Mapping foreign key to non primary surrogate key column in EF code first
- Create association on non-primary key fields with Entity Framework 4.1 Fluent API
- Entity Framework Code First - Foreign Key to non primary key field
- Use foreign keys as primary key
- Entity Framework Two foreign keys as primary key
- Primary /Foreign Key in Entity Framework
- Foreign key with EF 4 c#
- Entity Framework Foreign Key Issue