Monday, March 26, 2012 1:42 PM
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?
Tuesday, March 27, 2012 7:22 AM
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.
Resolving n Evolving in C# (http://jeanpaulva.com)
- Proposed As Answer by Bob Wu-MTMicrosoft Contingent Staff, Moderator Thursday, March 29, 2012 9:48 AM
- Marked As Answer by Bob Wu-MTMicrosoft Contingent Staff, Moderator Friday, April 06, 2012 7:40 AM
- Unmarked As Answer by Kumar Jalli Wednesday, April 18, 2012 6:32 AM
- Unproposed As Answer by Kumar Jalli Wednesday, April 18, 2012 6:35 AM
Wednesday, April 18, 2012 6:35 AM
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.....................