SqLiteGate class

April 28, 2021

Represents Korzh.EasyQuery.Db.DbGate implementation for SQLite databases

public class Korzh.EasyQuery.DbGates.SqLiteGate
    : DbGate

Package: Korzh.EasyQuery.SqLiteGate (targets: netstandard2.0)

Assembly: Korzh.EasyQuery.SqLiteGate.dll

Constructors

Name Type Description
SqLiteGate() void Initializes a new instance of the Korzh.EasyQuery.DbGates.SqLiteGate class.
SqLiteGate(SqliteConnection connection) void Initializes a new instance of the Korzh.EasyQuery.DbGates.SqLiteGate class.

Properties

Name Type Description
Connection SqliteConnection Gets the connection.

Methods

Name Type Description
AssembleConnectionString() string Builds the final connection string based on the string defined in Korzh.EasyQuery.Db.DbGate.ConnectionString property, current environment variables and the parameters defined in UserID and Password properties.
CoreCheckConnection() void Checks the connection. Connection is null
CoreGetFields(string dbName, string schemaName, string tableName, DbFieldInfoList fields) void Core implementation of Korzh.EasyQuery.Db.DbGate.GetFields(System.String,System.String,System.String) method.
CoreGetFieldsBySQL(string sql, DbFieldInfoList fields) void Core implementation of Korzh.EasyQuery.Db.DbGate.GetFieldsBySQL(System.String) method.
CoreGetLinks(string dbName, string schemaName, DbLinkInfoList links) void Core implementation of Korzh.EasyQuery.Db.DbGate.GetLinks(System.String,System.String) method.
CoreGetTables(string dbName, string schemaName, DbTableInfoList tables) void Core implementation of Korzh.EasyQuery.Db.DbGate.GetTables(System.String,System.String) method.
GetConnection() DbConnection When overriden in derived class, returns the connection
GetDataTypeBySqlType(string sqlType) DataType Gets the DataType enum value by by SQLite data type.
GetFormatType() FormatType Gets the type of the format.
GetGateId() string Gets the ID of Korzh.EasyQuery.Db.DbGate type.
GetName() string Gets the ID of Korzh.EasyQuery.Db.DbGate type.
SetConnection(DbConnection connection) void Sets the Microsoft.Data.Sqlite.SqliteConnection

Static Properties

Name Type Description
ConnectionType Type Gets the type of the connection.

Static Methods

Name Type Description
Register() void Registers this type of DbGate in global list of DbGate types.