Cascading delete performance

[Rolf]

Hi

I need to implement cascading delete between related tables. I can do
this in sql server (2005) or in the dataset in my application. But what
is the best solution when perfermance is important ?

Thanks

Rolf

 

[W.G. Ryan - MVP]

Ultimately you'll need it done in both places won't you? If not then you'll
be dealing with data that isn't snychronized.

 

[Miha Markic [MVP C#]]

I would say database.

 

[Darren Kopp]

Deleting in the database will have the best performance, and will
handle data integrity the best.

To solve syncronization, just refill the dataset.

HTH,
Darren Kopp
http://blog.secudocs.com/