Class SqliteDatasourceConnection

Namespace

YndigoBlue.Velocity.Data.Sqlite

Assembly

YndigoBlue.Velocity.dll

Connection configuration for SQLite databases.

public class SqliteDatasourceConnection : DatasourceConnection, IDatasourceConnection

Inheritance

object

DatasourceConnection

SqliteDatasourceConnection

Implements

IDatasourceConnection

Remarks

Warning

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

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 "velocity.db", and additional schemas are stored as "{schemaname}.db".

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

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/velocity.db
    var schema = m.LoadSchema("velocity");

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

    // Perform database operations
}

Properties

DatasourceType

Gets the datasource type for SQLite.