ConnectionState - NotIn

A ConnectionState extension method that not in.

Try it

public static void Main()
{
	using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
    {		
		//C# Extension Method: ConnectionState - NotIn
        bool result1 = conn.State.NotIn(ConnectionState.Closed, ConnectionState.Open); // return false;
        bool result2 = conn.State.NotIn(ConnectionState.Open, ConnectionState.Executing); // return true;
        Console.WriteLine(result1);
		Console.WriteLine(result2);
    }
}

View Source
using System.Data;

public static partial class Extensions
{
    /// <summary>
    ///     A ConnectionState extension method that not in.
    /// </summary>
    /// <param name="this">The @this to act on.</param>
    /// <param name="values">A variable-length parameters list containing values.</param>
    /// <returns>true if it succeeds, false if it fails.</returns>
    public static bool NotIn(this ConnectionState @this, params ConnectionState[] values)
    {
        return values.IndexOf(@this) == -1;
    }
}