How to write transactions in C# and SQL

Santhosh Uj

7y895Learn iOS Programming

Hello Every one,

im new to Development

my question is how to write transactions in C# and SQL and is it good practice to write transactions in C# or SQL

thanks in advance

5 Replies

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

Rajeev Kumar3y ago
BEGIN TRAN

TRUNCATE TABLE Employees

ROLLBACK

SELECT * FROM Employees
Santhosh Uj7y ago
Thanks a lot to all
Sreekanth Reddy7y ago
Hi Santhosh,

I personally prefer and suggest you to write transactions in SQL Server side.
Let us think that we are having two command objects obj1 & obj2.
So, firstly we pass the obj1 and try to insert the parent or primary table stuff. if it gets error, We are again coming to the nextline & trying and executing the obj2. Which is meaningless. Directtly by executing a transaction in db via stored procedure makes really sense right ?
Hope you understood.
For working with transaction in C# :
https://www.c-sharpcorner.com/uploadfile/john_charles/using-transactions-in-ado-net/
If it helps mark as answer.
Thank you.
Priyanka Singh7y ago
For a beginner,you should try writing transactions first in sql.
First start with basics Transactions DDL,DML,DCL etc.
You should visit this Link
https://www.c-sharpcorner.com/article/transaction-in-net/
Sanwar Ranwa7y ago
Hello Santhosh

Please check these Links

https://www.youtube.com/watch?v=L_2xu8TgEiM

https://www.youtube.com/watch?v=shkt9Z5Gz-U

https://www.youtube.com/watch?v=Jpb2Fgkkmso

https://stackoverflow.com/questions/19165291/how-to-use-sqltransaction-in-c-sharp

https://codereview.stackexchange.com/questions/59863/transaction-handling-for-multiple-sql-statements

https://www.codeproject.com/Articles/10223/Using-Transactions-in-ADO-NET

https://www.codeproject.com/Articles/522039/%2FArticles%2F522039%2FA-Beginners-Tutorial-for-Understanding-Transaction