SslOptions Property

In This Topic

Gets or sets Devart.Data.PgSql.SslOptions object which is used to establish secure connection with server.

Syntax

Visual Basic
C#

'Declaration
 
Public Property SslOptions As SslOptions

public SslOptions SslOptions {get; set;}

Property Value

Devart.Data.PgSql.SslOptions object which is used to establish secure connection with server.

Remarks

You have to include "SSL=true" initialization parameter to ConnectionString to enable SSL data transfer.

Example

The following example shows how to enable SSL data transfer with dotConnect for PostgreSQL.

csharp

PgSqlConnection conn = new PgSqlConnection("user id=postgres;password=postgres;host=localhost;");
conn.SslOptions.CACert = "E:\\Test\\root.crt";
conn.SslOptions.Cert = "E:\\Test\\client.crt";
conn.SslOptions.Key = "E:\\Test\\client.key";
conn.SslOptions.SslMode = SslMode.Require;
conn.Open();

Visual Basic

Dim conn As PgSqlConnection = New PgSqlConnection("user id=postgres;password=postgres;host=localhost;")
conn.SslOptions.CACert = "E:\Test\root.crt"
conn.SslOptions.Cert = "E:\Test\client.crt"
conn.SslOptions.Key = "E:\Test\client.key"
conn.SslOptions.SslMode = SslMode.Require
conn.Open()

Reference

PgSqlConnection Class
PgSqlConnection Members
SslOptions Class

Send Feedback