Execution Timeout Expired - Randomly for simple update command

asp.net entity-framework-6 sql timeout

Popular Answer

this question

UPDATE [dbo].[EmployeeTable]
    SET [Name] = @0,
        [JoiningDate] = @1
    WHERE ([EmpId]=@2);

typically not take two seconds. Even on a somewhat big table, updating a single row would not take less than two seconds. Do you own a list ofEmployeeTable(EmpId) ? If not, it would account for the two seconds and the possibility of a stalemate.

If you do have an index, maybe there is another issue. Look for any triggers on the table as a starting point.

0
6/28/2017 11:30:09 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow