Skip to content

SqlClientGate class

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

public class Korzh.EasyQuery.DbGates.SqlClientGate
: DbGate
TypeNameDescription
SqlConnectionConnectionGets the System.Data.SqlClient.SqlConnection.
TypeNameDescription
voidCoreCheckConnection()Checks the connection. Connection is null
voidCoreGetDatabases(DbInfoList databases)Core implementation of Korzh.EasyQuery.Db.DbGate.GetDatabases method.
voidCoreGetFields(String dbName, String schemaName, String tableName, DbFieldInfoList fields)Core implementation of Korzh.EasyQuery.Db.DbGate.GetFields(System.String,System.String,System.String) method.
voidCoreGetFieldsBySQL(String sql, DbFieldInfoList fields)Core implementation of Korzh.EasyQuery.Db.DbGate.GetFieldsBySQL(System.String) method.
voidCoreGetLinks(String dbName, String schemaName, DbLinkInfoList links)Core implementation of Korzh.EasyQuery.Db.DbGate.GetLinks(System.String,System.String) method.
voidCoreGetTables(String dbName, String schemaName, DbTableInfoList tables)Core implementation of Korzh.EasyQuery.Db.DbGate.GetTables(System.String,System.String) method.
BooleanGetConnected()Core implemenation of “get” method of Korzh.EasyQuery.Db.DbGate.Connected property.
DbConnectionGetConnection()Gets the System.Data.SqlClient.SqlConnection.
DbDataAdapterGetDataAdapter(String sqlText)Returns new instance of System.Data.SqlClient.SqlDataAdapter.
DataTypeGetDataTypeBySqlType(String sqlType)Converts SQL type to DataType.
FormatTypeGetFormatType()Gets the type of the format.
StringGetGateId()Gets the ID of Korzh.EasyQuery.Db.DbGate type.
StringGetName()Gets the name of Korzh.EasyQuery.DbGates.SqlClientGate.
StringGetPwdName()Gets the name of “password” attribute in connection string.
StringGetSqlDialect()Gets the name of default SQL dialect.
StringGetUidName()Gets the name of User ID attribute in connection string
voidSetConnected(Boolean connected)Core implemenation of “set” method of Korzh.EasyQuery.Db.DbGate.Connected property.
TypeNameDescription
TypeConnectionTypeGets the type of the connection.
TypeNameDescription
voidRegister()Registers this type of DbGate in global list of DbGate types.