Your database includes a stored procedure named DeletePersonByID. You use the Entity Designer to add this stored procedure as a LINQ to SQL DataContext method. You need to ensure that the DataContext uses this stored procedure to delete a Person row when the SubmitChanges method is called after the corresponding Person entity is marked for deletion.
What should you do?

Use the Entity Designer to select the Person entity class and configure the Delete command to use the DeletePersonByID stored procedure. This configures the data context to use this stored procedure when changes are submitted to the database.

Configuring a return type will cause the data context to map the result set of a stored procedure to an entity class. It will not cause the stored procedure to be called on updates.