Npgsql.NpgsqlConnector.SetBackendCommandTimeout C# (CSharp) Method

SetBackendCommandTimeout() private method

Modify the backend statement_timeout value if needed.
private SetBackendCommandTimeout ( int timeout ) : void
timeout int New timeout
return void
        internal void SetBackendCommandTimeout(int timeout)
        {
            if (Mediator.BackendCommandTimeout == -1 || Mediator.BackendCommandTimeout != timeout)
            {
                NpgsqlCommand.ExecuteSetStatementTimeoutBlind(this, timeout);

                Mediator.BackendCommandTimeout = timeout;
            }
        }

Usage Example

        private static void ExecuteBlind(NpgsqlConnector connector, NpgsqlQuery query, int timeout)
        {
            // Block the notification thread before writing anything to the wire.
            using (var blocker = connector.BlockNotificationThread())
            {
                // Set statement timeout as needed.
                connector.SetBackendCommandTimeout(timeout);

                // Write the Query message to the wire.
                connector.Query(query);

                // Flush, and wait for and discard all responses.
                connector.ProcessAndDiscardBackendResponses();
            }
        }
All Usage Examples Of Npgsql.NpgsqlConnector::SetBackendCommandTimeout