Databases
StackOverflow2013
Postsdbo
POException Handling in EF when Try To Delete Not Cascaded Entity
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POException Handling in EF when Try To Delete Not Cascaded Entity
    primarykey
    data
    text
    <p>assume that there are two entity:</p> <pre><code>public class Category { public string Id { get; set; } public string Caption { get; set; } public string Description { get; set; } public virtual IList&lt;Product&gt; Products { get; set; } } public class Product { public string Id { get; set; } public string CategoryId { get; set; } public string Caption { get; set; } public string Description { get; set; } public virtual Category Category { get; set; } } </code></pre> <p>and the cascade delete are not allowed.</p> <pre><code>public class ProductMap : EntityTypeConfiguration&lt;Product&gt; { public ProductMap() { // Primary Key this.HasKey(t =&gt; t.Id); // Properties this.Property(t =&gt; t.Caption) .IsRequired() .HasMaxLength(50); // Table &amp; Column Mappings this.ToTable("Products"); this.Property(t =&gt; t.Id).HasColumnName("Id"); this.Property(t =&gt; t.Caption).HasColumnName("Caption"); // Relationships this.HasRequired(t =&gt; t.Category) .WithMany(t =&gt; t.Products) .HasForeignKey(d =&gt; d.CategoryId) .WillCascadeOnDelete(false); } } </code></pre> <p>so when i want to delete a category that some products related to it, and DbUpdateException accurred. and in error message of exception write :</p> <pre><code>{"The DELETE statement conflicted with the REFERENCE constraint \"FK_dbo.Products_dbo.Categories_CategoryId\". The conflict occurred in database \"TestDb\", table \"dbo.Products\", column 'CategoryId'.\r\nThe statement has been terminated."} </code></pre> <p>there are any error code to find out that when accurred DbUpdateException this is related to deleting dont cascade records? i know sql server return error number 547 but what about entity framework?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPezhman Parsaee
    1. USPezhman Parsaee
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POException Handling in EF when Try To Delete Not Cascaded Entity
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat entity are you applying the fluent api to? What is `this`? Are you using Code First, Model First, or Database first?
      singulars
      1. POException Handling in EF when Try To Delete Not Cascaded Entity
      1. USJustin
    2. CO@Justin, please review this post again, i edit post at now, i am using code first
      singulars
      1. POException Handling in EF when Try To Delete Not Cascaded Entity
      1. USPezhman Parsaee
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload