SqlServerGate class
Represents Korzh.EasyQuery.Db.DbGate implementation for MS SQL databases
public class Korzh.EasyQuery.DbGates.SqlServerGate : DbGatePackage: Korzh.EasyQuery.SqlServerGate (targets: netstandard2.0)
Assembly: Korzh.EasyQuery.SqlServerGate.dll
Constructors
Section titled “Constructors”| Name | Type | Description |
|---|---|---|
| SqlServerGate() | void | Initializes a new instance of the SqlClientGate class. |
Properties
Section titled “Properties”| Name | Type | Description |
|---|---|---|
| Connection | SqlConnection | Gets the Microsoft.Data.SqlClient.SqlConnection. |
Methods
Section titled “Methods”| Name | Type | Description |
|---|---|---|
| CoreCheckConnection() | void | Checks the connection. |
| 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
Section titled “Static Properties”| Name | Type | Description |
|---|---|---|
| ConnectionType | Type | Gets the type of the connection. |
Static Methods
Section titled “Static Methods”| Name | Type | Description |
|---|---|---|
| Register() | void | Registers this type of DbGate in global list of DbGate types. |