I have a configuration like this in my codes: <pre class="prettyprint"><code>builder.HasMany(c => c.Libs) .WithOne(x=>x.Book) .HasForeignKey(x=>x.BookId) .OnDelete(DeleteBehavior.NoAction); <<-------- Here </code></pre> My question is what is different between <code>NoAction</code> and <code>Restrict</code> value? I read Microsoft document and descriptions of both of them are same!!! <img src="https://i.stack.imgur.com/BDZFw.png" alt="enter image description here">

It depends on the database implementation. In T-SQL and MySQL, there is no difference. In PostgreSQL, there is a difference: Difference between RESTRICT and NO ACTION

What is different between DeleteBehavior.NoAction and DeleteBehavior.Restrict in EntityFramework Core?

Tags:

entity-framework

entity-framework-core

I have a configuration like this in my codes:

builder.HasMany(c => c.Libs)
       .WithOne(x=>x.Book)
       .HasForeignKey(x=>x.BookId)
       .OnDelete(DeleteBehavior.NoAction);  <<-------- Here

My question is what is different between NoAction and Restrict value?

I read Microsoft document and descriptions of both of them are same!!!

enter image description here

633

asked Oct 08 '20 09:10

Ramin Bateni

1 Answers

It depends on the database implementation.

In T-SQL and MySQL, there is no difference.

In PostgreSQL, there is a difference: Difference between RESTRICT and NO ACTION

159

answered Oct 06 '22 02:10

arni

Related questions
                            
                                How to compare minutes portion only of a TimeSpan in LINQ to Entities?
                            
                                Asp.net MVC - How to hash password
                            
                                Can't call DeleteObject in Entity framework - missing an assembly reference?
                            
                                Lambda Expression for Latest Date
                            
                                Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
                            
                                Why does Entity Framework 6 generate complex SQL queries for simple lookups?
                            
                                Entity framework 6 and spatial data
                            
                                How to construct a dynamic where filter in EF.Core to handle equals, LIKE, gt, lt, etc
                            
                                ASP.NET MVC without Models and Entity Framework [closed]
                            
                                Populate Created and LastModified automagically in EF Core
                            
                                Entity Framework .net: "The Name value should be a valid navigation property name."
                            
                                Entity framework async issues context or query?
                            
                                Add Or Condition to Entity in Entity Framework
                            
                                Distinct in Entity framework
                            
                                How to hide Entity Framework entity properties from strongly typed views?
                            
                                Simple delete query using EF Code First
                            
                                Picking random record from Entity Framework database without OrderBy