Using SSL with dotConnect for PostgreSQL from NuGet

Using SSL with dotConnect for PostgreSQL from NuGet

When using dotConnect for PostgreSQL via NuGet packages, note that SSL support is not included in the NuGet assemblies by default.
​
To enable SSL connections, you must manually add the necessary assemblies from the full Devart installation package to your project:
​

  

 

After adding the required libraries, configure the connection using the appropriate ConnectionString parameters. See the official documentation for details:
👉 PgSqlConnection.ConnectionString
 
Key SSL-related connection string parameters:


SSL CA Cert

The location of the authority SSL certificate.
Ssl Cert
The location of the client SSL certificate.
Ssl Cipher List
The list of ciphers that client agrees to use.
Ssl Key
The location of the user's private key.
Ssl Mode
SSL connection priority. May be Disable, Allow, Prefer, and Require. The default value is Disable, which means that only an unencrypted SSL connection will be attempted.
SSL TLS Protocol
Specifies the maximal TLS version to report to the server when establishing a connection. Supported values are "1.0", "1.1", and "1.2". The default value is "1.1".

 

For more advanced configuration, refer to the SslOptions property:
👉 PgSqlConnection.SslOptions