Create association on non-primary key fields with Entity Framework 4.1 Fluent API

by

It is not possible. Relations in EF follows exactly same rules as in the database. It means that principal table must have unique identifier which is referenced by dependent table. In case of database the identifier can be either primary key or unique column(s) of principal table. Otherwise it is not valid relation.

Entity framework doesn’t support unique keys. If you want to have one-to-many relation between Report and RunStat your dependent table (RunStat) must contains column with value of Report.ReportKey. There is no other way to make it automatic – otherwise you must simply make it custom property and fill it from entity framework manually when you need it.

More Related Contents:

  1. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  2. Entity Framework Code First – two Foreign Keys from same table
  3. Ignoring a class property in Entity Framework 4.1 Code First
  4. Entity Framework Join 3 Tables
  5. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  6. composite key as foreign key
  7. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  8. Is it possible to capture a 0..1 to 0..1 relationship in Entity Framework?
  9. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  10. EF Code First: How to get random rows
  11. Understanding ForeignKey attribute in entity framework code first
  12. Navigation Property without Declaring Foreign Key
  13. Better way to query a page of data and get total count in entity framework 4.1?
  14. Entity Framework 4: How to find the primary key?
  15. An error occurred while saving entities that do not expose foreign key properties for their relationships
  16. Can you get the DbContext from a DbSet?
  17. Entity Framework Code First Date field creation
  18. mapping multiple tables to a single entity class in entity framework
  19. Create code first, many to many, with additional fields in association table
  20. EntityFramework – contains query of composite key
  21. EF codefirst : Should I initialize navigation properties?
  22. Update Row if it Exists Else Insert Logic with Entity Framework [closed]
  23. The type of one of the expressions in the join clause is incorrect in Entity Framework
  24. Using DataAnnotations with Entity Framework
  25. EF 6 – How to correctly perform parallel queries
  26. When should I create a new DbContext()
  27. EF 6 Parameter Sniffing
  28. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  29. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  30. Entity Framework: field of composite key cannot be nullable?

Leave a Comment