Thursday, February 16, 2012

ASP.NET SQL Server Transactions

Hi,
I am currently having dificulties in finding a way to use transactions while using classes for table representation.
Let me explain, i have two tables a Customers and a Movements one, so two tables = two classes. Each class supports Insert, Edit and Delete, so if this tables worked seperatly there would be no problem but in this case whenever i create a customer i must create a movement for that customer so the connection don't pass between classes and i cannot use transactions ;(
Is there any brilliant way to use transactions any other way? Even between connections or getting a solution for my implementation?
Best Regards,
Luis Sim?esRun a search for Cascade Delete and Cascade Update and DRI(declarative referenctial integrity) Triggers in SQL Server BOL(books online). Hope this helps.

No comments:

Post a Comment