How do I manage SQL transactions in C#?

How do I manage SQL transactions in C#?

To manage SQL transactions in C#, you can use the SqlTransaction class. First, you need to create a SqlConnection and then begin a transaction using the BeginTransaction method.

Can you show me a code example?

Sure! Here's a simple example:

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlTransaction transaction = connection.BeginTransaction();
    try
    {
        SqlCommand command = connection.CreateCommand();
        command.Transaction = transaction;

        command.CommandText = "INSERT INTO Table1 (Column1) VALUES ('Value1')";
        command.ExecuteNonQuery();

        command.CommandText = "INSERT INTO Table2 (Column2) VALUES ('Value2')";
        command.ExecuteNonQuery();

        transaction.Commit();
    }
    catch
    {
        transaction.Rollback();
        throw;
    }
} 

What happens if I don't commit the transaction?

If you don't commit the transaction, all the changes made during that transaction will be rolled back, and the database will remain unchanged.

Are there any best practices for using transactions?

Yes, some best practices include keeping transactions short, handling exceptions properly, and ensuring that you always commit or roll back the transaction.