I am developing a project, in that i use SQL Transactions to begin a
transaction like if i want to save the details of the user along with the
Address first i will save the details of the user and then the address.
in my database i have these type of files: Person, user, Address,
userAddress : person will have the details like personID, firstName,
LastName, SSN . . .
and user will userid, PersonID, . . . .
and in the same way Address will have a unique AddressID and this adddress
id will be corelated in UserAddress.
for this type of transactions i use SQL transactions.
but when i was going thorough a Micorsoft Enterprise Example : Duwamish i
came accross DataSet Transactions. in that, if there are any transactions he
first performs all the transactions in the DataSet and then update the
database.
SQLDataAdapter.Fill(Destination, Source)
from the above scenario which one is most reliable. . .
Thankyou,
Raghuram.