Interface IDatasourceConnection
- Namespace
- YndigoBlue.Velocity.Interfaces
- Assembly
- YndigoBlue.Velocity.dll
Defines connection parameters for database datasources.
public interface IDatasourceConnectionRemarks
Datasource connections encapsulate the information needed to connect to a database, including server location, credentials, connection pooling settings, and timeouts. Each database system has a concrete implementation (SqlServerDatasourceConnection, PostgreSqlDatasourceConnection, etc.) that provides system-specific connection string generation and default values. Advanced settings allow database-specific connection string parameters and runtime context configuration.
Properties
- CommandTimeout
Gets or sets the command execution timeout in seconds.
- ConnectTimeout
Gets or sets the connection timeout in seconds.
- Database
Gets or sets the database name or catalog to connect to.
- DatasourceType
Gets the type of database system for this connection.
- GeographySrid
Gets or sets the spatial reference identifier (SRID) applied to geography columns and values.
- GeometrySrid
Gets or sets the spatial reference identifier (SRID) applied to geometry columns and values.
- Hostname
Gets or sets the database server hostname or IP address.
- ImportBatchSize
Gets or sets the number of rows sent to the database per batch during an import.
- ImportTransaction
Gets or sets whether an import is wrapped in a transaction so a failure part-way through rolls it back.
- MaxPoolSize
Gets or sets the maximum number of connections in the connection pool.
- MinPoolSize
Gets or sets the minimum number of connections maintained in the connection pool.
- Password
Gets or sets the database authentication password.
- Pooling
Gets or sets whether connection pooling is enabled.
- Port
Gets or sets the database server port number.
- SslCaPath
Gets or sets the path to the CA certificate file used to verify the server's certificate. Required when SslMode is VerifyCA or VerifyFull.
- SslCertificatePath
Gets or sets the path to the client certificate file for mutual TLS authentication.
- SslKeyPath
Gets or sets the path to the client private key file for mutual TLS authentication.
- 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 database authentication username.
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)
Applies advanced connection string settings from a connection string builder.
- SetAdvancedSettings(string)
Parses and applies advanced connection string settings from a semicolon-separated key-value pair string.
- SetContextSettings(string)
Parses and applies runtime context settings specific to the database system.