IDbConnection - IsConnectionOpen
A DbConnection extension method that queries if a connection is open.
public static void Main() { using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer())) { //C# Extension Method: IDbConnection - IsConnectionOpen var result1 = conn.IsConnectionOpen(); // return false conn.EnsureOpen(); //C# Extension Method: IDbConnection - IsConnectionOpen var result2 = conn.IsConnectionOpen(); // return true Console.WriteLine(result1); Console.WriteLine(result2); } }
View Source
using System.Data; using System.Data.Common; public static partial class Extensions { /// <summary>A DbConnection extension method that queries if a connection is open.</summary> /// <param name="this">The @this to act on.</param> /// <returns>true if a connection is open, false if not.</returns> public static bool IsConnectionOpen(this DbConnection @this) { return @this.State == ConnectionState.Open; } }