Table of Contents

Class DatasourceConnection

Namespace
YndigoBlue.Velocity.Data
Assembly
YndigoBlue.Velocity.dll

Base class for all database connection configurations. Provides common connection properties and settings management.

public abstract class DatasourceConnection : IDatasourceConnection
Inheritance
DatasourceConnection
Implements
Derived

Remarks

This abstract class defines the core connection parameters used across all supported database types. Database-specific implementations inherit from this class and provide additional configuration options.

Properties

CommandTimeout

Gets or sets the default command timeout in seconds for database operations.

ConnectTimeout

Gets or sets the connection timeout in seconds.

Database

Gets or sets the database name to connect to.

DatasourceType

Gets the type of database system for this connection.

DefaultSrid

Gets or sets the default Spatial Reference System Identifier (SRID) applied to Geography columns.

Hostname

Gets or sets the database server hostname or IP address.

ImportBatchSize

Gets or sets the batch size for import operations.

ImportTimeout

Gets or sets the timeout in seconds for import operations.

ImportTransaction

Gets or sets whether import operations should be wrapped in a database transaction.

MaxPoolSize

Gets or sets the maximum number of connections in the connection pool.

MinPoolSize

Gets or sets the minimum number of connections in the connection pool.

Password

Gets or sets the password for database authentication.

Pooling

Gets or sets whether connection pooling is enabled.

Port

Gets or sets the port number for the database server.

SslCaPath

Gets or sets the path to the CA (Certificate Authority) certificate file used to verify the server's certificate (PEM format).

SslCertificatePath

Gets or sets the path to the SSL client certificate file (PEM or PFX format).

SslKeyPath

Gets or sets the path to the SSL client private key file (PEM format).

SslMode

Gets or sets the SSL/TLS encryption and certificate verification mode for this connection.

UseIntegratedSecurity

Gets or sets whether OS-level / integrated authentication is used instead of a username and password.

Username

Gets or sets the username for database authentication.

Methods

Clone(Action<IDatasourceConnection>)

Creates a copy of this connection with all property values duplicated. An optional configure action can be supplied to override specific properties on the copy.

SetAdvancedSettings(DbConnectionStringBuilder)

Parses advanced database-specific settings from a connection string builder and applies them to the connection.

SetAdvancedSettings(string)

Parses advanced database-specific settings from a connection string and applies them to the connection.

SetContextSettings(string)

Parses context settings and applies them to named connection properties.