Base solution for your next web application
Open Closed

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


User avatar
0
abu created

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)
  • User Avatar
    0
    hikalkan created
    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.