Why does Entity Framework over SQL Express ignore timeout?

Question

I have following connection string:

metadata=res:///Database.csdl|res:///Database.ssdl|res://*/Database.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename='Database.mdf';Integrated Security=True;User Instance=True;Connection Timeout=300;"

I expect that this connection string can never get timeout (because it is 5 mins). However, on a very easy database.table.Count() call to Entity Framework it fails in 10 seconds with "Timeout" exception. Why does Entity Framework ignores SQL timeout? How to set timeout for Entity Framework?

possible duplicate of Entity Framework Timeouts

Matt
– Matt

2013-11-07 08:29:25 +00:00
Commented Nov 7, 2013 at 8:29 — Matt
– Matt, Commented Nov 7, 2013 at 8:29

Damien_The_Unbeliever · Accepted Answer · 2011-12-13 12:21:55Z

3

Connection timeout specifies the amount of time to spend waiting for a connection. It doesn't affect the amount of time that a query can spend before timing out.

For that, you need to search for a CommandTimeout property on whatever database context class you're using.

answered Dec 13, 2011 at 12:21

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave Hogan · Accepted Answer · 2011-12-13 12:21:27Z

0

Connection Timeout is the amount of time to wait whilst attempting to connect to the DB server not executing a query

answered Dec 13, 2011 at 12:21

Dave Hogan

3,2216 gold badges31 silver badges55 bronze badges

Collectives™ on Stack Overflow

Why does Entity Framework over SQL Express ignore timeout?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related