Unique Key constraints for multiple columns in Entity Framework

by

With Entity Framework 6.1, you can now do this:

[Index("IX_FirstAndSecond", 1, IsUnique = true)]
public int FirstColumn { get; set; }

[Index("IX_FirstAndSecond", 2, IsUnique = true)]
public int SecondColumn { get; set; }

The second parameter in the attribute is where you can specify the order of the columns in the index.
More information: MSDN

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  3. Entity Framework 6 Code first Default value
  4. EntityFramework code-first custom connection string and migrations
  5. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  6. Improve navigation property names when reverse engineering a database
  7. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  8. How do I detach objects in Entity Framework Code First?
  9. EF5 Code First Enums and Lookup Tables
  10. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  11. Entity framework code-first null foreign key
  12. Entity Framework loading child collection with sort order
  13. Unique keys in Entity Framework 4
  14. How do I singularize my tables in EF Code First?
  15. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  16. How to create index in Entity Framework 6.2 with code first
  17. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  18. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  19. mapping private property entity framework code first [duplicate]
  20. What is the syntax for self referencing foreign keys in EF Code First?
  21. How to create index in Entity Framework 6.2 with fluent configuration
  22. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  23. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  24. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  25. EF Code First foreign key without navigation property
  26. Entity Framework Code First Using Guid as Identity with another Identity Column
  27. LINQ To Entities + Include + Anonymous type issue
  28. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  29. Can anyone spot why I keep getting this error testing the EF 5 beta
  30. Entity framework code first delete with cascade

Leave a Comment