what is difference between SqlTransaction and T-Sql(begin tran, commit tran, rollback tran)

[Junyin.Wu]

what is difference between SqlTransaction and T-Sql(begin tran, commit
tran, rollback tran)

thanks.

[Miha Markic [MVP C#]]

SqlTransaction is a class that calls TSql for you.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Junyin.Wu" <ta**********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

what is difference between SqlTransaction and T-Sql(begin tran, commit
tran, rollback tran)

thanks.

[Junyin.Wu]

you mean:
-----
SqlConnection.BeginTransaction();
SqlTransaction.Commit();
SqlTransaction.Rollback();
----
are equal to
---
SqlCommand.CommandText = "Begin Tran" // "Commit Tran" // "Rollback
Tran";
SqlCommand.ExecuteNonQurey();
----
?

Thanks.

[Miha Markic [MVP C#]]

Yup.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Junyin.Wu" <ta**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

you mean:
-----
SqlConnection.BeginTransaction();
SqlTransaction.Commit();
SqlTransaction.Rollback();
----
are equal to
---
SqlCommand.CommandText = "Begin Tran" // "Commit Tran" // "Rollback
Tran";
SqlCommand.ExecuteNonQurey();
----
?

Thanks.