Why is timeout occurring while executing a stored procedure in C# even after increasing the commandtimeout property?

Question

I have a piece of code that executes stored procedure.i have given a "Waitfor Delay '00:05' " in the SP for the purpose of testing the timeout in my C# code wherein my commandtimeout is set for 10 mins. While debugging, after 20 seconds or so when the executereader for the SP is executed,I am getting a timeout . Stuck on this for 2 days, any help is much appreciated.

Answer 1

Give ConnectionTimeout as 0, it means undefined waiting time.And one more thing , u can debug the SP using EXEC command in sql server itself and check where the time taking in code or in SP.

Connection Timout in code

SqlDataAdapter da = new SqlDataAdapter(Query, ConnectionString);
da.SelectCommand.CommandTimeout = 0;

Execute SP in sql server

EXEC procedure_name; 

Regards Aravind