Occurs when connection to the data source is lost in case
LocalFailover is set to
true. You may use this event to implicitly reconnect and reexecute the current operation.
The event handler receives an argument of type ConnectionLostEventArgs containing data related to this event. The following ConnectionLostEventArgs properties provide information specific to this event.
| Property | Description |
|---|
| AttemptNumber | The number of attempts to reconnect. |
| Cause | The reason of the connection loss. |
| Component | The object where the connection loss occurs. |
| Context | The state of the connection when connection is lost. |
| RetryMode | The application behavior when connection is lost. |
PgSqlConnection conn = new PgSqlConnection("host=server;database=test;user id=postgres;");
conn.LocalFailover = true;
conn.ConnectionLost += new ConnectionLostEventHandler(conn_ConnectionLost);
static void conn_ConnectionLost(object sender, ConnectionLostEventArgs e) {
if (e.Cause == ConnectionLostCause.Execute) {
if (e.Context == ConnectionLostContext.None)
e.RetryMode = RetryMode.Reexecute;
else
e.RetryMode = RetryMode.Raise;
}
else
e.RetryMode = RetryMode.Raise;
}
Dim conn As PgSqlConnection = New PgSqlConnection("host=server;database=test;user id=postgres;")
conn.LocalFailover = True
AddHandler conn.ConnectionLost, AddressOf conn_ConnectionLost
Sub conn_ConnectionLost(ByVal sender As Object, ByVal e As ConnectionLostEventArgs)
If e.Cause = ConnectionLostCause.Execute Then
If e.Context = ConnectionLostContext.None Then
e.RetryMode = RetryMode.Reexecute
Else
e.RetryMode = RetryMode.Raise
End If
Else
e.RetryMode = RetryMode.Raise
End If
End Sub