Essential ADO.NET

8.5. Implementing the Connection Class

To implement the Connection class, you start by implementing IDbConnection, shown in Listing 8-2. Note that IDbConnection inherits from IDisposable.

Listing 8-2. The IDbConnection interface

public interface IDbConnection : IDisposable { IDbTransaction BeginTransaction(IsolationLevel iso); IDbTransaction BeginTransaction(); bool ChangeDatabase(string newdb); void Close(); IDbCommand CreateCommand(); void Open(); // properties string ConnectionString {get; set;} int ConnectionTimeout {get; set;} string Database {get; set;} ConnectionState State {get;} }

8.5.1. Specification

IDbConnection has six public methods. The most obvious are Open and Close. Because the .NET runtime does not include the concept of ...