Used for the IDbConnection.State property, which describes the connection state. Fetching, Executing, Connecting, and Broken aren’t currently used by ADO.NET and are included to use when creating a custom provider and for future upgrades to the .NET framework.

public enum ConnectionState {

   Closed = 0x00000000,

   Open = 0x00000001,

   Connecting = 0x00000002,

   Executing = 0x00000004,

   Fetching = 0x00000008,

   Broken = 0x00000010



System.Object System.ValueType System.Enum(System.IComparable, System.IFormattable, System.IConvertible) ConnectionState

Returned By

IDbConnection.State, System.Data.OleDb.OleDbConnection.State, System.Data.OracleClient.OracleConnection.State, System.Data.SqlClient.SqlConnection.State, StateChangeEventArgs.{CurrentState, OriginalState}

Passed To

StateChangeEventArgs.StateChangeEventArgs( )

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.