OdbcConnection.State Property

Definition

Gets the current state of the connection.

C#
[System.ComponentModel.Browsable(false)]
public override System.Data.ConnectionState State { get; }
C#
[System.ComponentModel.Browsable(false)]
public System.Data.ConnectionState State { get; }

Property Value

A bitwise combination of the ConnectionState values. The default is Closed.

Implements

Attributes

Remarks

The following are allowed state changes:

  • From Closed to Open, using the Open method.

  • From Open to Closed, using either the Close or Dispose method.

Note

Calling the State property on an open connection increases application overhead because each such call causes a SQL_ATTR_CONNECTION_DEAD call to the underlying ODBC driver to determine whether the connection is still valid.

Applies to

Product Versions
.NET 8 (package-provided), 9 (package-provided)
.NET Framework 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7 (package-provided), 4.7, 4.7.1 (package-provided), 4.7.1, 4.7.2 (package-provided), 4.7.2, 4.8 (package-provided), 4.8, 4.8.1
.NET Standard 2.0 (package-provided)

See also