ExecuteSqlTransactionUsingTransactionScope

private static void ExecuteSqlTransactionUsingTransactionScope(string connectionString)
{
	using(TransactionScope scope = new TransactionScope()) 
	{
		using (SqlConnection connection = new SqlConnection(connectionString))
		{
			connection.Open();
			
			SqlCommand command = connection.CreateCommand();
			
			command.Connection = connection;

			command.CommandText = "Insert into MyTable(ColumnA, ColumnB) VALUES (1234, 'ValueB')";
			command.ExecuteNonQuery();

			command.CommandText = "Insert into MyTable(ColumnA, ColumnB) VALUES (5678, 'Another Value')";
			command.ExecuteNonQuery();

			Console.WriteLine("Both records are written to database.");
		}

		scope.Complete();
	}
}