Show / Hide Table of Contents

Class NpgsqlConnectionStringBuilder

Provides a simple way to create and manage the contents of connection strings used by the NpgsqlConnection class.

Inheritance
System.Object
NpgsqlConnectionStringBuilder
Implements
IDictionary<System.String, System.Object>
Namespace: Npgsql
Assembly: Npgsql.dll
Syntax
public sealed class NpgsqlConnectionStringBuilder : DbConnectionStringBuilder, IDictionary<string, object>

Constructors

NpgsqlConnectionStringBuilder()

Initializes a new instance of the NpgsqlConnectionStringBuilder class.

Declaration
public NpgsqlConnectionStringBuilder()

NpgsqlConnectionStringBuilder(Boolean)

Initializes a new instance of the NpgsqlConnectionStringBuilder class, optionally using ODBC rules for quoting values.

Declaration
public NpgsqlConnectionStringBuilder(bool useOdbcRules)
Parameters
Type Name Description
System.Boolean useOdbcRules

true to use {} to delimit fields; false to use quotation marks.

NpgsqlConnectionStringBuilder(String)

Initializes a new instance of the NpgsqlConnectionStringBuilder class and sets its .

Declaration
public NpgsqlConnectionStringBuilder(string connectionString)
Parameters
Type Name Description
System.String connectionString

Properties

ApplicationName

The optional application name parameter to be sent to the backend during connection initiation.

Declaration
public string ApplicationName { get; set; }
Property Value
Type Description
System.String

AutoPrepareMinUsages

The minimum number of usages an SQL statement is used before it's automatically prepared. Defaults to 5.

Declaration
public int AutoPrepareMinUsages { get; set; }
Property Value
Type Description
System.Int32

BackendTimeouts

Obsolete, see http://www.npgsql.org/doc/migration/3.1.html

Declaration
public bool BackendTimeouts { get; set; }
Property Value
Type Description
System.Boolean

CheckCertificateRevocation

Whether to check the certificate revocation list during authentication. False by default.

Declaration
public bool CheckCertificateRevocation { get; set; }
Property Value
Type Description
System.Boolean

ClientEncoding

Gets or sets the client_encoding parameter.

Declaration
public string ClientEncoding { get; set; }
Property Value
Type Description
System.String

CommandTimeout

The time to wait (in seconds) while trying to execute a command before terminating the attempt and generating an error. Defaults to 30 seconds.

Declaration
public int CommandTimeout { get; set; }
Property Value
Type Description
System.Int32

ConnectionIdleLifetime

The time to wait before closing idle connections in the pool if the count of all connections exceeds MinPoolSize.

Declaration
public int ConnectionIdleLifetime { get; set; }
Property Value
Type Description
System.Int32

The time (in seconds) to wait. The default value is 300.

ConnectionLifeTime

Obsolete, see http://www.npgsql.org/doc/migration/3.1.html

Declaration
public int ConnectionLifeTime { get; set; }
Property Value
Type Description
System.Int32

ConnectionPruningInterval

How many seconds the pool waits before attempting to prune idle connections that are beyond idle lifetime (ConnectionIdleLifetime.

Declaration
public int ConnectionPruningInterval { get; set; }
Property Value
Type Description
System.Int32

The interval (in seconds). The default value is 10.

ContinuousProcessing

Obsolete, see http://www.npgsql.org/doc/migration/3.1.html

Declaration
public bool ContinuousProcessing { get; set; }
Property Value
Type Description
System.Boolean

ConvertInfinityDateTime

Makes MaxValue and MinValue timestamps and dates readable as infinity and negative infinity.

Declaration
public bool ConvertInfinityDateTime { get; set; }
Property Value
Type Description
System.Boolean

Database

The PostgreSQL database to connect to.

Declaration
public string Database { get; set; }
Property Value
Type Description
System.String

Encoding

Gets or sets the .NET encoding that will be used to encode/decode PostgreSQL string data.

Declaration
public string Encoding { get; set; }
Property Value
Type Description
System.String

Enlist

Whether to enlist in an ambient TransactionScope.

Declaration
public bool Enlist { get; set; }
Property Value
Type Description
System.Boolean

EntityAdminDatabase

The database admin to specify when creating and dropping a database in Entity Framework. This is needed because Npgsql needs to connect to a database in order to send the create/drop database command. If not specified, defaults to "template1". Check NpgsqlServices.UsingPostgresDBConnection for more information.

Declaration
public string EntityAdminDatabase { get; set; }
Property Value
Type Description
System.String

EntityTemplateDatabase

The database template to specify when creating a database in Entity Framework. If not specified, PostgreSQL defaults to "template1".

Declaration
public string EntityTemplateDatabase { get; set; }
Property Value
Type Description
System.String
Remarks

http://www.postgresql.org/docs/current/static/manage-ag-templatedbs.html

Host

The hostname or IP address of the PostgreSQL server to connect to.

Declaration
public string Host { get; set; }
Property Value
Type Description
System.String

IncludeRealm

The Kerberos realm to be used for authentication.

Declaration
public bool IncludeRealm { get; set; }
Property Value
Type Description
System.Boolean

IntegratedSecurity

Whether to use Windows integrated security to log in.

Declaration
public bool IntegratedSecurity { get; set; }
Property Value
Type Description
System.Boolean

InternalCommandTimeout

The time to wait (in seconds) while trying to execute a an internal command before terminating the attempt and generating an error.

Declaration
public int InternalCommandTimeout { get; set; }
Property Value
Type Description
System.Int32

Item[String]

Gets or sets the value associated with the specified key.

Declaration
public override object this[string keyword] { get; set; }
Parameters
Type Name Description
System.String keyword

The key of the item to get or set.

Property Value
Type Description
System.Object

The value associated with the specified key.

KeepAlive

The number of seconds of connection inactivity before Npgsql sends a keepalive query. Set to 0 (the default) to disable.

Declaration
public int KeepAlive { get; set; }
Property Value
Type Description
System.Int32

KerberosServiceName

The Kerberos service name to be used for authentication.

Declaration
public string KerberosServiceName { get; set; }
Property Value
Type Description
System.String

Keys

Gets an ICollection{string} containing the keys of the NpgsqlConnectionStringBuilder.

Declaration
public ICollection<string> Keys { get; }
Property Value
Type Description
ICollection<System.String>

MaxAutoPrepare

The maximum number SQL statements that can be automatically prepared at any given point. Beyond this number the least-recently-used statement will be recycled. Zero (the default) disables automatic preparation.

Declaration
public int MaxAutoPrepare { get; set; }
Property Value
Type Description
System.Int32

MaxPoolSize

The maximum connection pool size.

Declaration
public int MaxPoolSize { get; set; }
Property Value
Type Description
System.Int32

MinPoolSize

The minimum connection pool size.

Declaration
public int MinPoolSize { get; set; }
Property Value
Type Description
System.Int32

NoResetOnClose

If set to true, a pool connection's state won't be reset when it is closed (improves performance). Do not specify this unless you know what you're doing.

Declaration
public bool NoResetOnClose { get; set; }
Property Value
Type Description
System.Boolean

Password

The password to connect with. Not required if using IntegratedSecurity.

Declaration
public string Password { get; set; }
Property Value
Type Description
System.String

PersistSecurityInfo

Gets or sets a Boolean value that indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.

Declaration
public bool PersistSecurityInfo { get; set; }
Property Value
Type Description
System.Boolean

Pooling

Whether connection pooling should be used.

Declaration
public bool Pooling { get; set; }
Property Value
Type Description
System.Boolean

Port

The TCP/IP port of the PostgreSQL server.

Declaration
public int Port { get; set; }
Property Value
Type Description
System.Int32

PreloadReader

Obsolete, see http://www.npgsql.org/doc/migration/3.0.html

Declaration
public bool PreloadReader { get; set; }
Property Value
Type Description
System.Boolean

ReadBufferSize

Determines the size of the internal buffer Npgsql uses when reading. Increasing may improve performance if transferring large values from the database.

Declaration
public int ReadBufferSize { get; set; }
Property Value
Type Description
System.Int32

SearchPath

Gets or sets the schema search path.

Declaration
public string SearchPath { get; set; }
Property Value
Type Description
System.String

ServerCompatibilityMode

A compatibility mode for special PostgreSQL server types.

Declaration
public ServerCompatibilityMode ServerCompatibilityMode { get; set; }
Property Value
Type Description
ServerCompatibilityMode

SocketReceiveBufferSize

Determines the size of socket read buffer.

Declaration
public int SocketReceiveBufferSize { get; set; }
Property Value
Type Description
System.Int32

SocketSendBufferSize

Determines the size of socket send buffer.

Declaration
public int SocketSendBufferSize { get; set; }
Property Value
Type Description
System.Int32

SslMode

Controls whether SSL is required, disabled or preferred, depending on server support.

Declaration
public SslMode SslMode { get; set; }
Property Value
Type Description
SslMode

TargetServerType

Gets or sets the PostgreSQL target server.

Declaration
public TargetServerType TargetServerType { get; set; }
Property Value
Type Description
TargetServerType

TcpKeepAliveInterval

The interval, in milliseconds, between when successive keep-alive packets are sent if no acknowledgement is received. Defaults to the value of TcpKeepAliveTime. TcpKeepAliveTime must be non-zero as well. Supported only on Windows.

Declaration
public int TcpKeepAliveInterval { get; set; }
Property Value
Type Description
System.Int32

TcpKeepAliveTime

The number of seconds of connection inactivity before a TCP keepalive query is sent. Use of this option is discouraged, use KeepAlive instead if possible. Set to 0 (the default) to disable. Supported only on Windows.

Declaration
public int TcpKeepAliveTime { get; set; }
Property Value
Type Description
System.Int32

Timeout

The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. Defaults to 15 seconds.

Declaration
public int Timeout { get; set; }
Property Value
Type Description
System.Int32

TrustServerCertificate

Whether to trust the server certificate without validating it.

Declaration
public bool TrustServerCertificate { get; set; }
Property Value
Type Description
System.Boolean

UseExtendedTypes

Obsolete, see http://www.npgsql.org/doc/migration/3.0.html

Declaration
public bool UseExtendedTypes { get; set; }
Property Value
Type Description
System.Boolean

UsePerfCounters

Writes connection performance information to performance counters.

Declaration
public bool UsePerfCounters { get; set; }
Property Value
Type Description
System.Boolean

Username

The username to connect with. Not required if using IntegratedSecurity.

Declaration
public string Username { get; set; }
Property Value
Type Description
System.String

UseSslStream

Npgsql uses its own internal implementation of TLS/SSL. Turn this on to use .NET SslStream instead.

Declaration
public bool UseSslStream { get; set; }
Property Value
Type Description
System.Boolean

Values

Gets an ICollection{string} containing the values in the NpgsqlConnectionStringBuilder.

Declaration
public ICollection<object> Values { get; }
Property Value
Type Description
ICollection<System.Object>

WriteBufferSize

Determines the size of the internal buffer Npgsql uses when writing. Increasing may improve performance if transferring large values to the database.

Declaration
public int WriteBufferSize { get; set; }
Property Value
Type Description
System.Int32

Methods

Add(KeyValuePair<String, Object>)

Adds an item to the NpgsqlConnectionStringBuilder.

Declaration
public void Add(KeyValuePair<string, object> item)
Parameters
Type Name Description
KeyValuePair<System.String, System.Object> item

The key-value pair to be added.

Clear()

Clears the contents of the NpgsqlConnectionStringBuilder instance.

Declaration
public override void Clear()

Contains(KeyValuePair<String, Object>)

Determines whether the NpgsqlConnectionStringBuilder contains a specific key-value pair.

Declaration
public bool Contains(KeyValuePair<string, object> item)
Parameters
Type Name Description
KeyValuePair<System.String, System.Object> item

The itemto locate in the NpgsqlConnectionStringBuilder.

Returns
Type Description
System.Boolean

true if the NpgsqlConnectionStringBuilder contains the entry; otherwise false.

ContainsKey(String)

Determines whether the NpgsqlConnectionStringBuilder contains a specific key.

Declaration
public override bool ContainsKey(string keyword)
Parameters
Type Name Description
System.String keyword

The key to locate in the NpgsqlConnectionStringBuilder.

Returns
Type Description
System.Boolean

true if the NpgsqlConnectionStringBuilder contains an entry with the specified key; otherwise false.

CopyTo(KeyValuePair<String, Object>[], Int32)

Copies the elements of the NpgsqlConnectionStringBuilder to an Array, starting at a particular Array index.

Declaration
public void CopyTo(KeyValuePair<string, object>[] array, int arrayIndex)
Parameters
Type Name Description
KeyValuePair<System.String, System.Object>[] array

The one-dimensional Array that is the destination of the elements copied from NpgsqlConnectionStringBuilder. The Array must have zero-based indexing.

System.Int32 arrayIndex

The zero-based index in array at which copying begins.

Equals(Object)

Determines whether the specified object is equal to the current object.

Declaration
public override bool Equals(object obj)
Parameters
Type Name Description
System.Object obj
Returns
Type Description
System.Boolean

GetEnumerator()

Returns an enumerator that iterates through the NpgsqlConnectionStringBuilder.

Declaration
public IEnumerator<KeyValuePair<string, object>> GetEnumerator()
Returns
Type Description
IEnumerator<KeyValuePair<System.String, System.Object>>

GetHashCode()

Hash function.

Declaration
public override int GetHashCode()
Returns
Type Description
System.Int32

GetProperties(Hashtable)

Declaration
protected override void GetProperties(Hashtable propertyDescriptors)
Parameters
Type Name Description
Hashtable propertyDescriptors

Remove(KeyValuePair<String, Object>)

Removes the entry from the DbConnectionStringBuilder instance.

Declaration
public bool Remove(KeyValuePair<string, object> item)
Parameters
Type Name Description
KeyValuePair<System.String, System.Object> item

The key/value pair to be removed from the connection string in this DbConnectionStringBuilder.

Returns
Type Description
System.Boolean

true if the key existed within the connection string and was removed; false if the key did not exist.

Remove(String)

Removes the entry with the specified key from the DbConnectionStringBuilder instance.

Declaration
public override bool Remove(string keyword)
Parameters
Type Name Description
System.String keyword

The key of the key/value pair to be removed from the connection string in this DbConnectionStringBuilder.

Returns
Type Description
System.Boolean

true if the key existed within the connection string and was removed; false if the key did not exist.

TryGetValue(String, out Object)

Retrieves a value corresponding to the supplied key from this NpgsqlConnectionStringBuilder.

Declaration
public override bool TryGetValue(string keyword, out object value)
Parameters
Type Name Description
System.String keyword

The key of the item to retrieve.

System.Object value

The value corresponding to the key.

Returns
Type Description
System.Boolean

true if keyword was found within the connection string, false otherwise.

Implements

IDictionary<, >
Back to top Copyright © 2015-2017 Microsoft
Generated by DocFX