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
{
createSqlTransa ction 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?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

<Ge***********@ web.de> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

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

Method A
{
createSqlTransa ction 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.

[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

--
Software Developer
http://www.xira.de
http://www.ci-gate.de