How to prevent timeout error when executing a SQL Server stored procedure in ASP.NET MVC?

Question

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.

Try to set the Connection Timeout=0; in connectionString of your web.config file — sri harsha
– sri harsha, Commented Dec 31, 2018 at 12:00
I have added Connection Timeout=0 in web.config, but sometimes it works, sometimes not. — user7094635
– user7094635, Commented Jan 1, 2019 at 11:48

Prashant Pimpale · Accepted Answer · 2018-12-31 12:29:36Z

0

You can set the Timeout Command to 0 when you are calling stored procedure.

using (SqlConnection connection = new SqlConnection(connectionString)) 
{
   connection.Open();  
   SqlCommand cmd= new SqlCommand(queryString, connection);  
   // Setting command timeout to 0 second  
   cmd.CommandTimeout = 0;  
   try 
   {  
     cmd.ExecuteNonQuery(); 
   }  
   catch(Exception ex)
   {
      // log ex here
   }
}

edited Dec 31, 2018 at 12:29

Prashant Pimpale

10.7k10 gold badges52 silver badges88 bronze badges

answered Dec 31, 2018 at 12:01

sandeep sharma

605 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to prevent timeout error when executing a SQL Server stored procedure in ASP.NET MVC?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related