title: How to prevent timeout error when executing a SQL Server stored procedure in ASP.NET MVC?
body: <p>I have a C# ASP.NET MVC program which runs a stored procedure while loading a page. If I run the stored procedure from Microsoft SQL Server Management Studio, it takes 1 minute. However, if I try to run the same stored procedure from code, it times out. 
  I have added Connection Timeout=0 in web.config, but sometimes it works, sometimes not.</p>