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" />