Class PostgreSqlConnectionStringBuilder

Namespace

Compendium.Adapters.PostgreSQL.Configuration

Assembly

Compendium.Adapters.PostgreSQL.dll

Helper class for building PostgreSQL connection strings with optimized pooling parameters. Enhances base connection strings with Npgsql-specific pooling configuration.

public static class PostgreSqlConnectionStringBuilder

Inheritance

object

PostgreSqlConnectionStringBuilder

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

BuildConnectionString(PostgreSqlOptions)

Builds an enhanced connection string with Npgsql pooling parameters from PostgreSqlOptions. If the base connection string already contains pooling parameters, they will be overridden.

public static string BuildConnectionString(PostgreSqlOptions options)

Parameters

options PostgreSqlOptions

The PostgreSQL configuration options.

Returns

string

A connection string with optimized pooling parameters.

Exceptions

ArgumentNullException

Thrown when options is null.

ArgumentException

Thrown when ConnectionString is null or empty.

GetConservativeOptions()

Gets a conservative configuration for moderate-load scenarios.

public static PostgreSqlOptions GetConservativeOptions()

Returns

PostgreSqlOptions

PostgreSqlOptions with balanced settings for moderate concurrency.

GetRecommendedProductionOptions()

Gets the recommended production configuration for high-load scenarios.

public static PostgreSqlOptions GetRecommendedProductionOptions()

Returns

PostgreSqlOptions

PostgreSqlOptions with optimized settings for 1000+ concurrent operations.

Validate(PostgreSqlOptions)

Validates that the connection string and pooling configuration are valid.

public static (bool IsValid, string? ErrorMessage) Validate(PostgreSqlOptions options)

Parameters

options PostgreSqlOptions

The PostgreSQL configuration options to validate.

Returns

(bool IsValid, string ErrorMessage)

A tuple indicating validation success and any error message.