Skip to main content

sqlitegate-class

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

public class Korzh.EasyQuery.DbGates.SqLiteGate
: DbGate

Assembly: Korzh.EasyQuery.SqLiteGate.dll

Constructors

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.

Properties

NameTypeDescription
ConnectionSqliteConnectionGets the connection.

Methods

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

Static Properties

NameTypeDescription
ConnectionTypeTypeGets the type of the connection.

Static Methods

NameTypeDescription
Register()voidRegisters this type of DbGate in global list of DbGate types.