Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Question

0.00/5 (No votes)

See more:

, +

I am getting the above error while executing a stored procedure through entity framework. While I run the SP directly on the SQL server through SQL management studio, it fetches all the data within 3-4 seconds.
I can avoid the timeout issue by increasing the CommandTimeOut property, but my question is why would entity framework take more time when the SP is returning the result in 4-5 seconds.

Is there something to do with the entity configuration part. Can anyone help me on this?

Thanks in advance.

Posted 29-Jan-14 3:24am

pulak_mj

Updated 29-Jan-14 3:33am

v2

Add a Solution

Comments

thatraja 29-Jan-14 9:57am

Share the SP content in your question

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ahmed Bensaid · Answer 1 · 2014-01-29T03:29:00

Solution 1

Take a look there ;)
http://stackoverflow.com/questions/6232633/entity-framework-timeouts[^]

Posted 29-Jan-14 3:29am

Ahmed Bensaid

Comments

pulak_mj 29-Jan-14 13:03pm

Unfortunately, the link did not help. I dont want to increase the timeout property. Since the SP is taking few seconds to fetch the data, The entity should also take only that amount of time. Thanks for your help.

Ahmed Bensaid 30-Jan-14 4:22am

And this : http://stackoverflow.com/questions/15772252/entity-framework-4-stored-procedure-call-timing-out