SqlClient.LastQueryTime Property

SqlClient LastQueryTime Property

Nemiro.Data.dll

Elapsed time of the last query to the database.

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: 2.11.4.126 (2.11.4.126)

Syntax

public TimeSpan LastQueryTime { get; }

public TimeSpan LastQueryTime { get; }

Public ReadOnly Property LastQueryTime As TimeSpan 
	Get

Public ReadOnly Property LastQueryTime As TimeSpan 
	Get

Property Value

Type: TimeSpan

Examples

C++

Copy to Clipboard Print

using (SqlClient client = new SqlClient())
{
  client.CommandText = "WAITFOR DELAY '00:00:03'";
  client.ExecuteNonQuery();
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime);
}

using (SqlClient client = new SqlClient())
{
  client.CommandText = "WAITFOR DELAY '00:00:03'";
  client.ExecuteNonQuery();
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime);
}

Using client As New SqlClient()
  client.CommandText = "WAITFOR DELAY '00:00:03'"
  client.ExecuteNonQuery();
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime);
End Using

Using client As New SqlClient()
  client.CommandText = "WAITFOR DELAY '00:00:03'"
  client.ExecuteNonQuery();
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime);
End Using