SqlClientGate class

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

public class Korzh.EasyQuery.DbGates.SqlClientGate
    : DbGate


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


Type Name Description
void CoreCheckConnection() Checks the connection.
void CoreGetDatabases(DbInfoList databases) Core implementation of Korzh.EasyQuery.Db.DbGate.GetDatabases method.
void CoreGetFields(String dbName, String schemaName, String tableName, DbFieldInfoList fields) Core implementation of Korzh.EasyQuery.Db.DbGate.GetFields(System.String,System.String,System.String) method.
void CoreGetFieldsBySQL(String sql, DbFieldInfoList fields) Core implementation of Korzh.EasyQuery.Db.DbGate.GetFieldsBySQL(System.String) method.
void CoreGetLinks(String dbName, String schemaName, DbLinkInfoList links) Core implementation of Korzh.EasyQuery.Db.DbGate.GetLinks(System.String,System.String) method.
void CoreGetTables(String dbName, String schemaName, DbTableInfoList tables) Core implementation of Korzh.EasyQuery.Db.DbGate.GetTables(System.String,System.String) method.
Boolean GetConnected() Core implemenation of "get" method of Korzh.EasyQuery.Db.DbGate.Connected property.
DbConnection GetConnection() Gets the System.Data.SqlClient.SqlConnection.
DbDataAdapter GetDataAdapter(String sqlText) Returns new instance of System.Data.SqlClient.SqlDataAdapter.
DataType GetDataTypeBySqlType(String sqlType) Converts SQL type to DataType.
FormatType GetFormatType() Gets the type of the format.
String GetGateId() Gets the ID of Korzh.EasyQuery.Db.DbGate type.
String GetName() Gets the name of Korzh.EasyQuery.DbGates.SqlClientGate.
String GetPwdName() Gets the name of "password" attribute in connection string.
String GetSqlDialect() Gets the name of default SQL dialect.
String GetUidName() Gets the name of User ID attribute in connection string
void SetConnected(Boolean connected) Core implemenation of "set" method of Korzh.EasyQuery.Db.DbGate.Connected property.

Static Methods

Type Name Description
void Register() Registers this type of DbGate in global list of DbGate types.