Command timeout with Entity Framework

aldare · Post by **aldare** » Mon 14 Dec 2009 09:04

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

AndreyR · Post by **AndreyR** » Mon 14 Dec 2009 11:43

We have implemented the "Command Timeout" connection string parameter.
Just append ";Command Timeout=" to your connection string.

aldare · Post by **aldare** » Mon 14 Dec 2009 12:36

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.

aldare · Post by **aldare** » Mon 14 Dec 2009 13:36

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.