Creating Composite Key Entity Framework

by

If Device table has composite primary key, then you need same composite foreign key on your NotificationMessageDevice table. How would SQL find Device without full primary key? Also you should make these fields to be part of NotificationMessageDevice table primary key. Otherwise you can’t guarantee primary key will be unique:

public class NotificationMessageDevice
{
    [Column(Order = 0), Key, ForeignKey("NotificationMessage")]
    public int NotificationMessage_ID { get; set; }

    [Column(Order = 1), Key, ForeignKey("Device")]
    public int Device_ID { get; set; }
    [Column(Order = 2), Key, ForeignKey("Device")]
    public string Device_UDID { get; set; }
    [Column(Order = 3), Key, ForeignKey("Device")]
    public string Device_ApplicationKey { get; set; }

    public virtual Device Device { get; set; }
    public virtual NotificationMessage NotificationMessage { get; set; }
}

More Related Contents:

  1. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  2. Entity Framework Join 3 Tables
  3. composite key as foreign key
  4. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  5. Non-static method requires a target
  6. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  7. Mapping Database Views to EF 5.0 Code First w/Migrations
  8. EF migration for changing data type of columns
  9. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  10. get date part only from datetime value using entity framework
  11. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  12. There is already an open DataReader associated with this Command which must be closed first
  13. MSSQL Error ‘The underlying provider failed on Open’
  14. Entity Framework Stored Procedure Table Value Parameter
  15. Method cannot be translated into a store expression
  16. How can I automatically filter out soft deleted entities with Entity Framework?
  17. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  18. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  19. Is it possible to capture a 0..1 to 0..1 relationship in Entity Framework?
  20. Dynamic MySQL database connection for Entity Framework 6
  21. How to disable cascade delete for link tables in EF code-first?
  22. Entity framework, problems updating related objects
  23. Dynamic table name in linq [duplicate]
  24. Entity Framework 6 transaction rollback
  25. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  26. How to group by DateTime.Date in EntityFramework
  27. Testing an Entity Framework database connection
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. How should I access a computed column in Entity Framework Code First?
  30. MVC 4 – Many-to-Many relation and checkboxes

Leave a Comment