Page 1 of 1

Command timeout with Entity Framework

Posted: Mon 14 Dec 2009 09:04
by aldare
Hello,

I would like to ask how to set the command timeout for long-running queries. Because we do use the Entity Framework and there are not DbCommands available, only DBConenction, there is no way how to set it up.

I spent some time by searching all the documentation and forums but haven't found anything. I think this basic functionality should be there. Does anybody know how to do that?

Thank you

Posted: Mon 14 Dec 2009 11:43
by AndreyR
We have implemented the "Command Timeout" connection string parameter.
Just append ";Command Timeout=" to your connection string.

Posted: Mon 14 Dec 2009 12:36
by aldare
Thank you for the answer.

We've got v. 5.25.39 and it is throwing an error : Unknown connection string parameter Command Timeout.

I will try to download the latest version.

Posted: Mon 14 Dec 2009 13:36
by aldare
If anyone is interested, the connection string attribute is neither CommandTimeout nor DefaultCommandTimeout (regarding to revision changes), but it is "default command timeout" (thanks to reflector).

Nevermind thanks, the problem seems to be SOLVED.