Logo ProcessCore

ISqliteDriver Type

Minimal driver contract implemented by runtime-specific SQLite adapters (ProcessCore.SQL.DotNet, ProcessCore.SQL.JavaScript, ProcessCore.SQL.Python).

The repository layer is written against this interface only — it has no knowledge of which physical SQLite engine is in use. All members are synchronous; async semantics, if needed, are the responsibility of the caller composing the driver.

Instance members

Instance member Description

this.Execute

Full Usage: this.Execute

Parameters:
    sql : string - The SQL text. Use parameter placeholders rather than string interpolation.
    parameters : SqlParameters - Parameters bound to the placeholders in sql.

Modifiers: abstract

Executes a non-query statement (INSERT/UPDATE/DELETE/DDL).

sql : string

The SQL text. Use parameter placeholders rather than string interpolation.

parameters : SqlParameters

Parameters bound to the placeholders in sql.

this.Query

Full Usage: this.Query

Parameters:
    sql : string - The SELECT (or other row-producing) statement.
    parameters : SqlParameters - Parameters bound to the placeholders in sql.

Returns: SqlRow[] An array of rows, each keyed by column name.
Modifiers: abstract

Executes a query and returns all rows.

sql : string

The SELECT (or other row-producing) statement.

parameters : SqlParameters

Parameters bound to the placeholders in sql.

Returns: SqlRow[]

An array of rows, each keyed by column name.

this.Scalar

Full Usage: this.Scalar

Parameters:
    sql : string - The query. The driver returns SqlValue.Null when no row is produced.
    parameters : SqlParameters - Parameters bound to the placeholders in sql.

Returns: SqlValue
Modifiers: abstract

Executes a query and returns the first column of the first row.

sql : string

The query. The driver returns SqlValue.Null when no row is produced.

parameters : SqlParameters

Parameters bound to the placeholders in sql.

Returns: SqlValue

Type something to start searching.