Begin, Commit, RollBackTransaction Difference in SQL Server and .NET

Question

Hi,

    I want to know the Begin, Commit, Rollback Transactions difference in SQL Server and .NET

and advantages and disadvantages

if single database server is using from multiple client systems to insert, update the data into same table at that time if we use transactions is there any problem or it is good?

Please Help,

Thank You

Answer 1

The Begin, Commit and Rollback works the same in SQL Server and .NET.

.Net ADO Library is having a wrapper of the above methods indeed which converts the method calls to SQL Statements and send to the server.

Transactions won't create any direct problems in case of multiple inserts/updates. (arises problems in some cases like Primary Key generation in transactions)

But Transactions are meant to target Atomic Operations.

link: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqltransaction.aspx

---

Resolving n Evolving in C# (http://jeanpaulva.com)

Answer 2

In SQL Server Transaction and .Net Transactions which one is better to use means using transactions in back end is good or using transactions in front end is good

waiting for reply.....................