Command timeout with Entity Framework

Command timeout with Entity Framework

Postby 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
aldare
 
Posts: 17
Joined: Mon 14 Dec 2009 08:55

Postby AndreyR » Mon 14 Dec 2009 11:43

We have implemented the "Command Timeout" connection string parameter.
Just append ";Command Timeout=" to your connection string.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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
 
Posts: 17
Joined: Mon 14 Dec 2009 08:55

Postby 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.
aldare
 
Posts: 17
Joined: Mon 14 Dec 2009 08:55


Return to dotConnect for Oracle