Is it possible to add CHECK constraint with fluent API in EF7?

entity-framework-core

Question

Is it possible to add CHECK constraint with fluent API in Entity Framework 7?

I need to acheive something like this:

...
ADD CONSTRAINT CK_SomeTable_SomeColumn CHECK (SomeColumn >= X);

It is ok if solution is provider-specific - I am targeting MsSqlServer only (at least now).

1
10
12/12/2015 9:55:19 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

As of EF 7.0.0-rc1, it isn't possible with the fluent API.

You can define the constraint manually in the migration

migrationBuilder.Sql("ALTER TABLE SomeTable ADD CONSTRAINT CK_SomeTable_SomeColumn CHECK (SomeColumn >= X);");
17
11/4/2019 5:29:39 PM

Popular Answer

As of EF Core 3.0, you can use 

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<SomeTable>(entity =>
        entity.HasCheckConstraint("CK_SomeTable_SomeColumn", "[SomeColumn] >= X");
}
Ryan Sparks

Related Questions

Setting unique Constraint with fluent API?

As an addition to Yorro's answer, it can also be done by using attributes....Sample for ...int... type unique key combination:...[Index("IX_UniqueKeyInt", IsUnique = true, Order = 1)] public int UniqueKeyIntPart1 { get; set; } [Index("IX_UniqueKeyInt", IsUnique = true, Order = 2)] public int UniqueKeyIntPart2 { get; set; } ...If the data type is ....
c# ef-fluent-api entity-framework entity-framework-6
asked by coni2k

How to add an index on multiple columns with ASC/DESC sort using the Fluent API?

You can make it manually editing Migrations like this :...public override void Up() { Sql("CREATE NONCLUSTERED INDEX [IX_Index_name] ON [dbo].[TableName] ([ColumnName1] Asc,[ColumnName2] Desc,[ColumnName3] Desc)"); } public override void Down() { Sql("DROP INDEX [dbo].[TableName].[IX_Index_name]"); }
ef-code-first ef-fluent-api entity-framework entity-framework-6 indexing
asked by Nikita

How to create two tables for single POCO using EF7 fluent API?

Ok, it seems like I can answer that question by myself....So, actually I have one ugly solution: using simple inheritance I can create identical entity that can be used for create another DbSet in same DbContext....Also, in order to avoid engagement of EF inheritance strategy, I need to leave base type unmapped (i.e. I don't need any inheritance-co...
c# ef-code-first entity-framework entity-framework-core
asked by rtf_leg

ASP.NET add migration 'composite primary key error' how to use fluent API

On ...EF core .....Composite keys can only be configured using the Fluent API - conventions will never setup a composite key and you can not use Data Annotations to configure one....Here is the ...Fluent API... version :...Note:... This is just an example. Please adjust it according to your use case....protected override void OnModelCreating(Mo...
asp.net c# entity-framework entity-framework-core
asked by Sampath

Adding unique identifier with Fluent API

Luckily EF Core allows you to define and use ...Shadow property... as PK....For instance, the following fluent configuration will create identity column named "Id" and use it as PK:...modelBuilder.Entity<Message>() .Property<int>("Id") .ValueGeneratedOnAdd(); modelBuilder.Entity<Message>() .HasKey("Id"); ...ValueGeneratedOnAdd... and ....
c# entity-framework-core fluent sql
asked by Ivan Stoev

Is it possible to set up this relationship via the Fluent API?

Upon some offline advice from an EF expert, I have worked around this issue by removing the navigation property for PackageEntry.Package and simply manually handle the foreign key for that package entity....Once I did that, now when the Parent Package entity is loaded, it properly loads the children PackageEntries....So, the PackageEntry class now ...
ef-code-first ef-fluent-api entity-framework-core
asked by G_P

Using Fluent Api to set foreign key constraint in Entity Framework Core 2.1

Both ...EntityTypeBuilder.HasOne... overloads have a ...navigationName... parameter that defaults to ...null.... The docs state that "If no property is specified, the relationship will be configured without a navigation property on this end."...The ...ReferenceNavigationBuilder.WithMany(String)... method's ...collection... parameter also defaults t...
.net-standard-2.0 ef-fluent-api entity-framework-core
asked by Alex Bello

EF Core Fluent API - unique constraint not being detected/included in migration

Use ...IsUnique... and ...HasIndex... methods in you DBContext class's ...OnModelCreating... method to add the composite key to your table. Then add migration using ...Add-Migration <YourMigrationName>... and then run ...Update-Database... in Program Manager Console. ...modelBuilder.Entity<PlasmidStockCode>(b => { b.HasIndex(e => (new {...
c# ef-fluent-api entity-framework-core sql-server
asked by vivek nuna

Unable to add API Controller to .NET Core 3 API Project

Go to API dependencies then add the second project, ...Add the namespace in EF Core models....namespace Sample.Core.Operations.SampleEF { public class Request { } } ...Create the class like:...Core.Operations.SampleEF.Request request
.net-core entity-framework-core
asked by Ąńťø Şhęlťôŋ

ASP.NET Core Web API & Entity Framework Core; why am I getting this error?

So that problem was that I was returning an EntityFramework core class from the controller. The reason this surprised me, is that the object being returned did not have any relationships, but just the mere fact that other objects that mContext interacted with did, caused the entire response to error.
asp.net-core asp.net-web-api c# entity-framework-core
asked by Tom Crosman

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow