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.
Showing posts with label classes. Show all posts
Showing posts with label classes. Show all posts
Thursday, February 16, 2012
ASP.NET SQL Server Transactions
Labels:
aspnet,
classes,
database,
dificulties,
explain,
microsoft,
mysql,
oracle,
representation,
server,
sql,
table,
transactions
Subscribe to:
Posts (Atom)