Which one is better one SQL or DataSet Transactions

[Microsoft]

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.

 

[Thomas Tomiczek [MVP]]

Two nots.

First, I am sure your name is not "Microsoft" - which basically puts you
into the dump idiot category.

Second, there ARE NO DATASET TRANSACTIONS. DataSets have no transactions.

--
Regards

Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)
(CTO PowerNodes Ltd.)

 

[Val Mazur \(MVP\)]

Hi,

I do not think there is a difference in reliability because transaction in a
..NET is just a wrapper for the same transaction on a server side. It is
probably about what would be easier for you to code. In a case if you open
transaction using .NET code you should less worry about scope of the
transaction, because transaction is
opened in your code, you do all the updates against this transaction and it
is done. In a case of transaction inside of SP, you need to maintain
transaction somehow as a global in a case if you first need to send your
client information and then send address information in another SP. When you
open transaction inside of SP then it will be local to this SP and it could
be an issue for you.

 

[Frans Bouma [C# MVP]]

Two nots.

First, I am sure your name is not "Microsoft" - which basically puts you
into the dump idiot category.

Second, there ARE NO DATASET TRANSACTIONS. DataSets have no transactions.

Third, you're not an MVP anymore, please remove 'MVP' from your
signature and name while posting here. Thanks.

Frans

 

[Thomas Tomiczek [MVP]]

I am very sorry, I AM an MVP.

MVP is an award. I am a three time MVP winner.

I may not be one of the last year's MVP winners, Frans, but you should
really get a clue what MVP means. It is an AWARD. Not a certificate.

It is new to me that awards do expire.

--
Regards

Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)
(CTO PowerNodes Ltd.)
---

Still waiting for ObjectSpaces? Try the EntityBroker today - more versatile,
more powerfull.
And something in use NOW. for the projects you have to deliver - NOW.

 

[Randy Collins]

Frans needs to get a life.

I am very sorry, I AM an MVP.

MVP is an award. I am a three time MVP winner.

I may not be one of the last year's MVP winners, Frans, but you should
really get a clue what MVP means. It is an AWARD. Not a certificate.

It is new to me that awards do expire.

--
Regards

Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)
(CTO PowerNodes Ltd.)
---

Still waiting for ObjectSpaces? Try the EntityBroker today - more versatile,
more powerfull.
And something in use NOW. for the projects you have to deliver - NOW.