Hi All,

I am able to delete mapping table values in different tables using "delete cascade" ie I can delete using back end Database directly. I want to know the same can be implemented from code behind using C#. What will be the syntax to be followed and constraints to consider.




Thanks

Prasanna

__________________
Thanks

Prasanna

Huh? Cascade operations are for relational databases. How are you expecting to do this in code? What in code are you deleting that you want to cascade to?

-Peter

Hi Peter,

Thanks for the reply,
I want to write a code which deletes a row, while deleting this row it needs to consider if any foreign key associated with this row. If yes then it need to delete that value before deleting present row. I have done this using SQL and presently trying if this is possible from C#, as this gives me full control of database.
Hope am clear with my question.


Thanks

Prasanna

Is there a reason you can not use the built in cascade delete functionality of the database engine?

Are the foreign keys known or unknown? Would you want the relationships to be discovered by the code? That would be a rather complex task as you would have to query schema tables to discover what other tables relate to the one you are initially deleting from.

-Peter

Hi Peter,

You are Right, can you please give a small example of how to get the relations using C#. Using code, we should be able to check foreign key and then delete..




Thanks

Prasanna

Prasanna,

If you look at Peter's post, you will see:
So I think asking for code may be a little.. inappropriate.
I think it would be a bad idea to do all this in code.. This sort of thing should definately be put on to the server. By definition, the Database Management System should be managing the data, both access and integrity.

If you have already done this in SQL, why bother moving it to the code?

Regards,

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

Thanks Peter and Rob for your valuable inputs,
I was assuming that my client should have full control the database.
Views appreciated

Thanks

Prasanna