Revisions to Entity Framework Core add unique constraint code-first

added 2 characters in body

edited Feb 11, 2019 at 8:56

66.2k
70
327
461

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs{Db}Context.cs:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

...or if you're using the overload with the buildAction:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>(entity => { entity.HasIndex(e => e.Email).IsUnique(); }); }

You can read more about it here : Indexes

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

...or if you're using the overload with the buildAction:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>(entity => { entity.HasIndex(e => e.Email).IsUnique(); }); }

You can read more about it here : Indexes

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

...or if you're using the overload with the buildAction:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>(entity => { entity.HasIndex(e => e.Email).IsUnique(); }); }

You can read more about it here : Indexes

code aligned

Source Link

edited Oct 29, 2018 at 15:54

Massimiliano Kraus

3.9k
5
32
51

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

 protected override void OnModelCreating(ModelBuilder builder)  {   builder.Entity<User>()   .HasIndex(u => u.Email)   .IsUnique();  }

...or if you're using the overload with the buildAction:

 protected override void OnModelCreating(ModelBuilder builder)  {   builder.Entity<User>(entity => {   entity.HasIndex(e => e.Email).IsUnique();   });  }

You can read more about it here : Indexes

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

 protected override void OnModelCreating(ModelBuilder builder)  {   builder.Entity<User>()   .HasIndex(u => u.Email)   .IsUnique();  }

...or if you're using the overload with the buildAction:

 protected override void OnModelCreating(ModelBuilder builder)  {   builder.Entity<User>(entity => {   entity.HasIndex(e => e.Email).IsUnique();   });  }

You can read more about it here : Indexes

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

...or if you're using the overload with the buildAction:

protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>(entity => { entity.HasIndex(e => e.Email).IsUnique(); }); }

You can read more about it here : Indexes

Added an example for configuing the index inside an EntityTypeBuilder action.

Source Link

edit approved Mar 23, 2018 at 18:56

Rich

2.3k
1
16
14

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

 protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

...or if you're using the overload with the buildAction:

 protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>(entity => { entity.HasIndex(e => e.Email).IsUnique(); }); }

You can read more about it here : Indexes

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

 protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

You can read more about it here : Indexes

On EF core you cannot create Indexes using data annotations.But you can do it using the Fluent API.

Like this inside your {Db}Context.cs:

 protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>() .HasIndex(u => u.Email) .IsUnique(); }

...or if you're using the overload with the buildAction:

 protected override void OnModelCreating(ModelBuilder builder) { builder.Entity<User>(entity => { entity.HasIndex(e => e.Email).IsUnique(); }); }

You can read more about it here : Indexes

changed variable name to match the one .net core generates DbContexts. And specified which file the code is to be put (which is clear from the external link)

Source Link