Within a procedure i create two connection

RConnection for readonly operation
WConnection for write operation on a DB.

Associated with the WConnection i create a Transaction with
isolationlevel ReadUncommitted;

All three object are stored in Session variables.

I use a class to perform operation on a DB and i need to have all
operation that could
modify the DB within the transaction

Here is the code :


string StrConn = "User ID="+UID+";Password="+PWD+";Initial
Catalog=Media;Data Source=(local)";

WConnection.ConnectionString = StrConn;
RConnection.ConnectionString = StrConn;

RConnection.Open();
WConnection.Open();

WTransaction =
WConnection.BeginTransaction(IsolationLevel.ReadUn committed);


Session["WConnection"] = WConnection;
Session["RConnection"] = RConnection;
Session["WTransaction"] = WTransaction;


In another procedure (within another asp.net page) i create an istance
of my object
and associate the connection


Document newDoc = new Document();
newDoc.Connection = WConnection;
newDoc.Transaction = WTransaction;

newDoc.Create(); // this insert a record in a table

in a second procedure i read the document list stored on the DB
Document Doc = new Document();
Doc.Connection = RConnection;
Doc.List();

Here is the code of the metod List()

SqlDataAdapter myCommand = new SqlDataAdapter("Document_List",
myConnection);
myCommand.SelectCommand.CommandType =
CommandType.StoredProcedure;
... // code for parameter of the storedprocedure
myCommand.ExecuteNonQuery();


At this point the program interrupts and this message is shown :
Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding.


If i was clear, can someone help me to understand what happens?
Does the transaction block the execution of the storedprocedure?

--
Posted via [url]http://dbforums.com[/url]