Composite Key with EF 4.1 Code First

by

You can mark both ActivityID and ActivityName properties with Key annotation or you can use fluent API as described by @taylonr.

Edit:

This should work – composite key defined with annotations requires explicit column order:

public class ActivityType
{
    [Key, Column(Order = 0)]
    public int ActivityID { get; set; }

    [Key, Column(Order = 1)]
    [Required(ErrorMessage = "A ActivityName is required")]
    [StringLength(50, ErrorMessage = "Activity Name must not exceed 50 characters")]
    public string ActivityName { get; set; }

}

More Related Contents:

  1. How do I define a database view using Entity Framework 4 Code-First?
  2. Code-first vs Model/Database-first [closed]
  3. Unique key with EF code first
  4. What effect(s) can the virtual keyword have in Entity Framework 4.1 POCO Code First?
  5. EntityType ‘IdentityUserLogin’ has no key defined. Define the key for this EntityType
  6. Ignoring a class property in Entity Framework 4.1 Code First
  7. One DbContext per request in ASP.NET MVC (without IOC container)
  8. composite key as foreign key
  9. How to delete and recreate from scratch an existing EF Code First database
  10. Entity Framework code first. Find primary key
  11. EF Code First: How to get random rows
  12. How do I detach objects in Entity Framework Code First?
  13. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  14. EF Code First – 1-to-1 Optional Relationship
  15. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  16. Entity framework code-first null foreign key
  17. Using mvc-mini-profiler database profiling with Entity Framework Code First
  18. How to configure many to many relationship using entity framework fluent API
  19. How to map table splitting in EF Code First?
  20. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  21. Navigation Property without Declaring Foreign Key
  22. How I can read EF DbContext metadata programmatically?
  23. An error occurred while saving entities that do not expose foreign key properties for their relationships
  24. Entity Framework Database.SetInitializer simply not working
  25. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  26. Convert DBContext to ObjectContext for use with GridView
  27. Model First with DbContext, Fails to initialize new DataBase
  28. Map Many to Many relationship without navigation property
  29. Integration Testing Entity Framework code first with in-memory database
  30. Getting exact error type in from DbValidationException

Leave a Comment