Skip to content

SqLiteGate class

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

NameTypeDescription
SqLiteGate()voidInitializes a new instance of the Korzh.EasyQuery.DbGates.SqLiteGate class.
SqLiteGate(SqliteConnection connection)voidInitializes a new instance of the Korzh.EasyQuery.DbGates.SqLiteGate class.
NameTypeDescription
ConnectionSqliteConnectionGets the connection.
NameTypeDescription
AssembleConnectionString()stringBuilds 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()voidChecks the connection. Connection is null
CoreGetFields(string dbName, string schemaName, string tableName, DbFieldInfoList fields)voidCore implementation of Korzh.EasyQuery.Db.DbGate.GetFields(System.String,System.String,System.String) method.
CoreGetFieldsBySQL(string sql, DbFieldInfoList fields)voidCore implementation of Korzh.EasyQuery.Db.DbGate.GetFieldsBySQL(System.String) method.
CoreGetLinks(string dbName, string schemaName, DbLinkInfoList links)voidCore implementation of Korzh.EasyQuery.Db.DbGate.GetLinks(System.String,System.String) method.
CoreGetTables(string dbName, string schemaName, DbTableInfoList tables)voidCore implementation of Korzh.EasyQuery.Db.DbGate.GetTables(System.String,System.String) method.
GetConnection()DbConnectionWhen overriden in derived class, returns the connection
GetDataTypeBySqlType(string sqlType)DataTypeGets the DataType enum value by by SQLite data type.
GetFormatType()FormatTypeGets the type of the format.
GetGateId()stringGets the ID of Korzh.EasyQuery.Db.DbGate type.
GetName()stringGets the ID of Korzh.EasyQuery.Db.DbGate type.
SetConnection(DbConnection connection)voidSets the Microsoft.Data.Sqlite.SqliteConnection
NameTypeDescription
ConnectionTypeTypeGets the type of the connection.
NameTypeDescription
Register()voidRegisters this type of DbGate in global list of DbGate types.