OdbcConnection.State Property

Definition

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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), 10 (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, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard 2.0 (package-provided)

See also