Breaking

Friday, July 12, 2019

How to fix the timeout expired in C#.net and MS sql server?

If your query needs more than the default 30 seconds,





Set the Timeout in connectionstring like Timeout="400000";

or 

  • use the below code for ADO.NET connection:

1.     declare "Connect Timeout" in the connection string
        Database=WIMS;Server=(local);User Id =(Username); Password=(password);Connect                              Timeout=3000000"

2.     SqlCommand.CommandTimeout
        using (var connection = new SqlConnection(connectionString))
        {

         connection.Open();
         SqlCommand command = new SqlCommand("SpGetEmployee", connection);
         command.CommandType = CommandType.StoredProcedure;

         // Setting command timeout to 3000000 second

         command.CommandTimeout = 3000000;
         command.ExecuteNonQuery();
        }

  • In entity framework you can use the below code:
 
<add name="TestEntities" connectionString="metadata=res://*/DbManager.Model1.csdl|res://*/DbManager.Model1.ssdl|res://*/DbManager.Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=00.00.000.000;initial catalog=Test;user id=sa;password=12345;MultipleActiveResultSets=True;Timeout=4000000;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />


  

1 comment:

  1. While finding examples out of information, AI attempts to search for certain examples or quest for certain information relationship in a circumstance where labeled information is missing. ExcelR Data Science Courses

    ReplyDelete