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

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.