Breaking News: Grepper is joining You.com. Read the official announcement!

db command execution time timeout c#

Mahesh Kumar Yadav answered on July 5, 2023 Popularity 1/10 Helpfulness 1/10

answer db command execution time timeout c#

db command execution time timeout c#

Comment

//SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
// To replcate this error
using System;  
using System.Data.SqlClient;  
///   
public class A {  
   ///   
   public static void Main() {  
      string connectionString = "";  
      // Wait for 5 second delay in the command  
      string queryString = "waitfor delay '00:00:05'";  
      using (SqlConnection connection = new SqlConnection(connectionString)) {  
         connection.Open();  
         SqlCommand command = new SqlCommand(queryString, connection);  
         // Setting command timeout to 1 second  
         command.CommandTimeout = 1;  
         try {  
            command.ExecuteNonQuery();  
         }  
         catch (SqlException e) {  
            Console.WriteLine("Got expected SqlException due to command timeout ");  
            Console.WriteLine(e);  
         }  
      }  
   }  
}

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# database

Link to this answer
Share Copy Link

Contributed on Jul 05 2023

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

db command execution time timeout c#

Contents

More Related Answers

db command execution time timeout c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.