.NET Client Behavior During Node Failure

You definitely have automatic high availability if you have 3 or more nodes and auto-failover enabled. Auto-failover failover is not on by default.