Post reply

WAITFOR being ignored in stored proc only when called from EF

  • October 19, 2015 at 11:20 am

    #312344

    We're trying to troubleshoot a timeout issue, so it was requested that I add a WAITFOR statement (1 hour) in a certain stored proc our application uses. I added it and confirmed that it was working by executing the stored proc in SSMS.

    However, when our application (using Entity Framework) calls the stored proc, the WAITFOR statement is ignored. Any ideas what might be causing this?

  • October 19, 2015 at 11:23 am

    #1834151

    Could it be that EF is using 2 different connections? One for the WAITFOR and one for the other code.

    Or is it inside a stored procedure that's being called from EF?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 19, 2015 at 11:32 am

    #1834154

    It's inside a stored proc being called by EF.

  • October 19, 2015 at 11:34 am

    #1834155

    It would help if we could see the code from the stored procedure.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 19, 2015 at 11:42 am

    #1834158

    Problem solved. Was given the wrong stored proc to modify. Ugh.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply