Class OracleDatasourceConnection
- Namespace
- YndigoBlue.Velocity.Connections
- Assembly
- YndigoBlue.Velocity.dll
Connection configuration for Oracle databases.
public class OracleDatasourceConnection : DatasourceConnection, IDatasourceConnection- Inheritance
-
OracleDatasourceConnection
- Implements
Examples
// Connect to Oracle with TNS connection
var conn = new OracleDatasourceConnection
{
Hostname = "localhost",
Port = 1521,
Database = "ORCL",
Username = "system",
Password = "oracle"
};
using (var m = new Manager(conn))
{
var schema = m.LoadSchema("MYSCHEMA");
// Perform database operations
}Remarks
WARNING: Oracle database support is not available in the Community Edition of Velocity. It requires the Full Edition.
Supports Oracle 12c and later versions.
Default port: 1521
Includes support for tablespaces and spatial tolerance settings.
Properties
- DatasourceType
Gets the datasource type for Oracle.
- ReservedSettings
Gets the reserved connection string settings that are handled by named properties.
- Tablespace
Gets or sets the default tablespace for database objects.
- Tolerance
Gets or sets the tolerance for spatial operations. Default is 0.01.
- UseBooleanDataType
Gets or sets whether to use Oracle's native boolean data type (Oracle 23c+). Default is false.