Class SqliteDatasourceConnection

Namespace

YndigoBlue.Velocity.Connections

Assembly

YndigoBlue.Velocity.dll

Connection configuration for SQLite databases.

public class SqliteDatasourceConnection : DatasourceConnection, IDatasourceConnection

Inheritance

object

DatasourceConnection

SqliteDatasourceConnection

Implements

IDatasourceConnection

Examples

// Connect to SQLite with file-based database
var conn = new SqliteDatasourceConnection
{
    Database = "./mydata"  // Folder path
};

using (var m = new Manager(conn))
{
    // Main database file: ./mydata/main.db
    var schema = m.LoadSchema("main");

    // Additional schema file: ./mydata/app.db
    var appSchema = m.LoadSchema("app");

    // Perform database operations
}

Remarks

WARNING: SQLite database support is not available in the Community Edition of Velocity. It requires the Full Edition.

Supports SQLite 3.x and later versions.

SQLite uses a folder-based approach for multi-schema support. The Database property represents a folder path, and each schema is stored as a separate .db file within that folder.

The main schema is stored as "main.db", and additional schemas are stored as "{schemaname}.db".

Cross-schema queries are supported through SQLite's ATTACH DATABASE feature.

Properties

DatasourceType

Gets the datasource type for SQLite.

MainDatabasePath

Gets or sets the full path to the main database file

ReservedSettings

Gets the reserved connection string settings that are handled by named properties.

Methods

GetSchemaPath(string)

Gets the full path to a schema database file.

PopulateAdvancedSettings()

PopulateContextSettings()