Just specify a cascade delete rule on the foreign key. If you are using a code-first approach you can do it on your db context: Cascade delete - EF Core

Otherwise directly in the database: SQL Server delete cascade

Have a look at