How We Cascading(On delete/On update) in asp.net Boilerplate #316

abu created 9 years ago

getting this error during update the database in package Manager Console

Introducing FOREIGN KEY constraint 'FK_dbo.Client_dbo.User_UpdatedByUserId' on table 'Client' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

how we cascade ON Delete and OnUpdate

please help

1 Answer(s)

0

hikalkan created 9 years ago
Support Team

Hi,

This is EF and SQL Server related issue. If you are using Code First Migrations, you could remove "cascade: true" from the generated migrations. If you applied migrations to production, then you can create a new migration to remove cascades. Since this is not related to ABP, you can find better information (probably some sample code) on the web easily.

Have an answer to this question? Log in and write your answer.