Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Sql Transaction and Commit in Asp.net C#

Home
Forums
Learn iOS Programming

Sql Transaction and Commit in Asp.net C#

Z Hussain

7yAsked Dec 25, 2018, 5:58 PM1.1kLearn iOS Programming

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Jignesh Kumar7y ago
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/
+1
Code Alone7y ago
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
+1