EF Code First Fluent API define unique constraint

Question

Im trying to enforce unique constraint of a column using fluent configuration for code first. Is there any better way than implementing it in business logic or using something like below

context.ObjectContext.ExecuteStoreCommand("CREATE UNIQUE CONSTRAINT...");

Or I was wondering if it's not possible to implement unique constrain using fluent configurations?

EDIT :

It's confirmed that this is not possible with fluent configurations. But then again I'm wondering what's the best way to do this? And would like to know the reason behind EF not supporting this.

The team is considering: entityframework.codeplex.com/workitem/299 — ErikEJ
– ErikEJ, Commented Mar 19, 2013 at 17:59

Imran Rashid · Accepted Answer · 2013-07-05 09:28:49Z

2

In this example you can see how to define a Unique key attribute and use it in any Entity.

http://code.msdn.microsoft.com/windowsdesktop/CSASPNETUniqueConstraintInE-d357224a

answered Jul 5, 2013 at 9:28

Imran Rashid

3,5124 gold badges33 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Geethanga Over a year ago

Thanks for the reply Imran. Actually it's a good way to do it. But in the end what it does is executing a vendor specific SQL statement, so in case I change my database to a different vendor I will end up modifying the code. But I do agree I will have to modify only one place.

czclk · Accepted Answer · 2013-03-18 13:12:33Z

1

I have this problem occurred before

it can not implement unique constrain using fluent API。

so, the way you used is correct!

answered Mar 18, 2013 at 13:12

czclk

1571 silver badge6 bronze badges

1 Comment

Geethanga Over a year ago

thanks for the reply. But if I do it using a command it will be dependent of my database implementation. That's something I don't want to have.

Ben Ripley · Accepted Answer · 2014-02-13 19:16:51Z

1

This is possible with DbMigrations...

public override void Up()
{
    CreateIndex("dbo.MyTableName", "MyColumnName", unique: true); 
}

answered Feb 13, 2014 at 19:16

Ben Ripley

2,16522 silver badges34 bronze badges

2 Comments

Geethanga Over a year ago

Yes indeed, I also have written a blog post on that you can find it here (geethanga.com/2013/11/adding-unique-constraints-entity.html). But my original question was if there's a way to do it with Fluent API.

g45rg34d Over a year ago

The problem with putting custom code into migrations is that you risk losing that code when you decide to purge/combine/regenerate your migrations. I suggest keeping all your configurations in the EntityTypeConfiguration classes. Check my answer on how to it: stackoverflow.com/a/25779397/111438.

Community · Accepted Answer · 2017-05-23 12:23:06Z

1

It can be done with a custom extension method:

using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Infrastructure.Annotations;
using System.Data.Entity.ModelConfiguration.Configuration;

internal static class TypeConfigurationExtensions
{
    public static PrimitivePropertyConfiguration HasUniqueIndexAnnotation(
        this PrimitivePropertyConfiguration property, 
        string indexName,
        int columnOrder = 0)
    {
        var indexAttribute = new IndexAttribute(indexName, columnOrder) { IsUnique = true };
        var indexAnnotation = new IndexAnnotation(indexAttribute);

        return property.HasColumnAnnotation("Index", indexAnnotation);
    }
}

Check the full answer here: https://stackoverflow.com/a/25779348/111438

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Sep 11, 2014 at 4:59

g45rg34d

9,6907 gold badges69 silver badges88 bronze badges

Collectives™ on Stack Overflow

EF Code First Fluent API define unique constraint

4 Answers 4

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related