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


Name Type Description
SqlServerGate() void Initializes a new instance of the SqlClientGate class.


Name Type Description
Connection SqlConnection Gets the Microsoft.Data.SqlClient.SqlConnection.


Name Type Description
CoreCheckConnection() void Checks the connection. Connection is null
CoreGetDatabases(DbInfoList databases) void Core implementation of Korzh.EasyQuery.Db.DbGate.GetDatabases 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 Gets the Microsoft.Data.SqlClient.SqlConnection.
GetDataAdapter(string sqlText) DbDataAdapter Returns new instance of Microsoft.Data.SqlClient.SqlDataAdapter.
GetDataTypeBySqlType(string sqlType) DataType Converts SQL type to DataType.
GetFormatType() FormatType Gets the type of the format.
GetGateId() string Gets the ID of Korzh.EasyQuery.Db.DbGate type.
GetName() string Gets the name of Korzh.EasyQuery.DbGates.SqlServerGate.
GetPwdName() string Gets the name of "password" attribute in connection string.
GetSqlDialect() string Gets the name of default SQL dialect.
GetTableFieldsMap(string dbName, string schemaName) Dictionary<string, DbFieldInfoList>
GetUidName() string Gets the name of User ID attribute in connection string
SetConnection(DbConnection connection) void Sets the Microsoft.Data.SqlClient.SqlConnection

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.