Unique key with EF code first

by

Unfortunately you can’t define it as unique key in code first because EF doesn’t support unique keys at all (it is hopefully planned for next major release). What you can do is to create custom database intializer and add unique index manually by calling SQL command:

public class MyInitializer : CreateDatabaseIfNotExists<MyContext>
{
  protected override void Seed(MyContext context)
  {
    context.Database.ExecuteSqlCommand("CREATE UNIQUE INDEX IX_Category_Title ON Categories (Title)");
  }
}

And you must set this initializer in the bootstrap of your application.

Database.SetInitializer<MyContext>(new MyInitializer());

Edit

Now (EF 6.1 onwards )you can easily have unique constrains ,

[Index("TitleIndex", IsUnique = true)]
 public string Title { get; set; }

More Related Contents:

  1. Ignoring a class property in Entity Framework 4.1 Code First
  2. EF Code First: How to get random rows
  3. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  4. EF Code First – how to set identity seed?
  5. How to configure many to many relationship using entity framework fluent API
  6. Navigation Property without Declaring Foreign Key
  7. An error occurred while saving entities that do not expose foreign key properties for their relationships
  8. Entity Framework Join 3 Tables
  9. Is DbContext thread safe?
  10. The entity type is not part of the model for the current context
  11. EF Including Other Entities (Generic Repository pattern)
  12. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  13. How to retrieve Data Annotations from code? (programmatically)
  14. ICollection Vs List in Entity Framework
  15. Entity Framework Code First Lazy Loading
  16. Calculated column in EF Code First
  17. Can a DbContext enforce a filter policy?
  18. Entity Framework 4.1 InverseProperty Attribute
  19. EF5 Code First – Changing A Column Type With Migrations
  20. Optimistic concurrency: IsConcurrencyToken and RowVersion
  21. Better way to query a page of data and get total count in entity framework 4.1?
  22. EF4 Code First: how to add a relationship without adding a navigation property
  23. Can you get the DbContext from a DbSet?
  24. How to Specify Primary Key Name in EF-Code-First
  25. What is the difference between IDbSet.Add and DbEntityEntry.State = EntityState.Added?
  26. DbSet table name
  27. Entity Framework: Duplicate Records in Many-to-Many relationship
  28. Mixing Fluent API and DataAnnotations in EF code first
  29. mapping multiple tables to a single entity class in entity framework
  30. Entity Framework: field of composite key cannot be nullable?

Leave a Comment