Is it important to Open a sql connection in the transactionscope.

Question

I created a sqlconnection, CN1. Then this CN1 is opened. Later in the code there is a transactionscope. If I execute a sql command on this CN1 connection, is this within transaction?

Code looks like this;

SqlConnection cn1 = new SqlConnection();
cn1.Open(); //connection opened when there is no ambient transaction.
...

using(TransactionScope scope = new TransactionScope())
{
  SqlCommand cmd; //a typical sql command.

  ...

  cmd.ExecuteNonQuery(); //Is this command within transaction?
  ...
}

Answer 1

It is better to open the connection within the TransactionScope to ensure that the connection is enrolled in the transaction.

See the comment just above the connection.Open in this MSDN example.

Answer 2

1. No, command is not executed in transaction
2. Open connection inside the scope or use EnlistTransaction method of SqlConnection instance. See my answer in different thread.