Skip to content

SqlServerGate class

Represents Korzh.EasyQuery.Db.DbGate implementation for MS SQL databases

public class Korzh.EasyQuery.DbGates.SqlServerGate
: DbGate

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

Assembly: Korzh.EasyQuery.SqlServerGate.dll

NameTypeDescription
SqlServerGate()voidInitializes a new instance of the SqlClientGate class.
NameTypeDescription
ConnectionSqlConnectionGets the Microsoft.Data.SqlClient.SqlConnection.
NameTypeDescription
CoreCheckConnection()voidChecks the connection. Connection is null
CoreGetDatabases(DbInfoList databases)voidCore implementation of Korzh.EasyQuery.Db.DbGate.GetDatabases 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()DbConnectionGets the Microsoft.Data.SqlClient.SqlConnection.
GetDataAdapter(string sqlText)DbDataAdapterReturns new instance of Microsoft.Data.SqlClient.SqlDataAdapter.
GetDataTypeBySqlType(string sqlType)DataTypeConverts SQL type to DataType.
GetFormatType()FormatTypeGets the type of the format.
GetGateId()stringGets the ID of Korzh.EasyQuery.Db.DbGate type.
GetName()stringGets the name of Korzh.EasyQuery.DbGates.SqlServerGate.
GetPwdName()stringGets the name of “password” attribute in connection string.
GetSqlDialect()stringGets the name of default SQL dialect.
GetTableFieldsMap(string dbName, string schemaName)Dictionary<string, DbFieldInfoList>
GetUidName()stringGets the name of User ID attribute in connection string
SetConnection(DbConnection connection)voidSets the Microsoft.Data.SqlClient.SqlConnection
NameTypeDescription
ConnectionTypeTypeGets the type of the connection.
NameTypeDescription
Register()voidRegisters this type of DbGate in global list of DbGate types.