sql server - How do I raise error if the execution of an SQL Query is not completed in specified time in C#?

Question

I'm trying to raise a timeout error in my SQL Server query using c#. I thought a timer would work; however I'm new to c# and have been having trouble figuring it out. I've searched through several questions on this site, and on other sites trying to find out how to raise a timeout error of my query.

Here is my code:

using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = query;
                cmd.CommandTimeout = timeOut;
                cmd.Connection = DBAction.GetSqlConnection(projectId);
                SqlDataReader reader = cmd.ExecuteReader();
                
                    string[] colname = Enumerable.Range(0, reader.FieldCount).Select(x => reader.GetName(x)).ToArray();
                    while (reader.Read())
                            {
                                 //do something
                            }       
            }

I'm not sure on how to add a timer to this that returns an error when the execution of the query takes longer than the specified time, or even where to put it. I've tried finding other posts about it but none of the ones I've found are similar to this; I could also just be really bad at my searches. Any kind of help would be appreciated, and if you need any more information let me know. I renamed a few things for security, but this is how the code is otherwise. To note: I'm using this for testing purposes, and not for production, so only a few people will ever actually see this but it's necessary.

question from:https://stackoverflow.com/questions/65904636/how-do-i-raise-error-if-the-execution-of-an-sql-query-is-not-completed-in-specif

Answer 1

Waitting for answers