SQLException timeout with nested Queries

[Gerrit.Horeis]

Hi All,
I have a problem with nested SQLQueries. I will give here an abstract
sample of code which I wrote

Method A
{
createSqlTransaction and
call SQL Insert Statement including "Select ScopeIdentity();"
try
{
call Method B
}
catch
{
Rollback Transaction
}
}

Method B
{
call another SQL Insert Statement including "Select ScopeIdentity();"
....
}


In "Method B" I get an SQLException with a Timeout Errormessage.

Can somebody help me?

Thanks in advance.

 

[Nicholas Paldino [.NET/C# MVP]]

Does it indicate what kind of timeout it is? Is it a timeout on the
transaction, or a timeout on the command?

 

[Gerrit]

It was a timeout on the SqlCommand object. I found out, that Sql-Server
can not handle nested transactions. The solution was to create an
SqlCommand object and bind a transaction to it. Then I assign the
SqlCommand object via reference to other methods where i can reuse the
object and in errorcase can rollback the transaction.

I just have to keep in mind to close the connection in the parent
method.

Thanks for all answers!

Greetings

Gerrit Horeis