using System.Data.SqlClient; using System.Transactions; public class ExampleClass { private readonly IDbHelper _dbHelper; public ExampleClass(IDbHelper dbHelper) { _dbHelper = dbHelper; } public void ExecuteTransaction() { using (var transaction = new TransactionScope()) { try { // Perform database operations here _dbHelper.CommitTransaction(); transaction.Complete(); } catch (SqlException sqlException) { // Handle SQL exceptions here } catch (Exception exception) { // Handle other exceptions here } } } }
using System.Data.SqlClient; using Dapper; public class ExampleClass { private readonly IDbHelper _dbHelper; public ExampleClass(IDbHelper dbHelper) { _dbHelper = dbHelper; } public void UpdateData(int id, string name) { using (var connection = new SqlConnection("In this example, we use the Dapper ORM library to perform a database operation. We first create a connection to the database and start a transaction. We then use the connection object to execute a SQL query and update a record in the MyTable table. If the operation is successful, we call the IDbHelper CommitTransaction method to commit the transaction to the database. If there are any exceptions, we rollback the transaction and handle the exceptions accordingly. The package library for IDbHelper is not specified in the code examples. It could be a custom or third-party library.")) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { var affectedRows = connection.Execute( "UPDATE MyTable SET Name = @Name WHERE Id = @Id", new { Id = id, Name = name }, transaction: transaction); _dbHelper.CommitTransaction(); transaction.Commit(); } catch (SqlException sqlException) { transaction.Rollback(); // Handle SQL exceptions here } catch (Exception exception) { transaction.Rollback(); // Handle other exceptions here } } } } }