Sql Transaction and Commit in Asp.net C#

Question

How Important is to use SQL Transactions and Commit in Asp.net C#? I am working on a Web Application and not sure that I would want to use Transactions and Commit Process in it. Would appreciate if someone can explain me the impact of using it Thanks in advance!

Jignesh Kumar · Answer

Hi Zack, A transaction is a single unit of work which means either ALL or NONE. If a transaction is successful, all of the data operations are committed and become a durable part of the database. If a transaction encounters errors/exceptions or fail and must be canceled or rolled back, then all of the data modifications/ operations need to be read off and database should be in previous state. Please find below links for reference https://www.c-sharpcorner.com/article/transaction-in-net/ https://www.c-sharpcorner.com/UploadFile/718fc8/working-with-sqltransaction-class-in-ado-net/ https://www.c-sharpcorner.com/UploadFile/87b416/sql-transaction/

Code Alone · Answer

Hi Jack, This is best article for your query : https://www.c-sharpcorner.com/article/transaction-in-net/ for more detail you ca refer microsoft documentation from : https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.begintransaction?view=netframework-4.7.2

Sql Transaction and Commit in Asp.net C#

Answers (2)