LinqDataSource Cascading Delete from a GridView

Question

 

Does anyone know of a good way to do a Cascading Delete from a GridView using a LinqDataSource?

 

I currently have a relationship that looks like Customer has an Address.  When I delete customer I would like to delete the orphaned address at the same time.  The delete from the LinqDataSource doesn't seem to take this relationship into account.  Any ideas? 

 

Thanks,

 

John

Answer 1

As far as I know, you can do the cascading delete in database side, for example sql server has such a setting in foreign key settings.

Thanks

Answer 2

You can uset the DeleteCustomer() Partial method of the DataContext class to perform the cascaded Delete

For example

 

Code Block

public partial class MyDataContext

{

partial void DeleteCustomer(Customer instance)

{

var DeletedAddresses = from a in Address

where a.CustomerID = instance.CustomerID

select a;

Adress.RemoveAll(DeletedAddresses);

SubmittChanges();

//or use this line if you have an association

Address.RemoveAll(instance.Address);

Submittchanges();

}