SqlClientGate class

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

public class Korzh.EasyQuery.DbGates.SqlClientGate
    : DbGate

Properties

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

Methods

Type Name Description
void CoreCheckConnection() Checks the connection. Connection is null
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 Properties

Type Name Description
Type ConnectionType Gets the type of the connection.

Static Methods

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