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
Constructors
| Name | Type | Description |
|---|---|---|
| SqlServerGate() | void |
Initializes a new instance of the SqlClientGate class. |
Properties
| Name | Type | Description |
|---|---|---|
| Connection | SqlConnection |
Gets the Microsoft.Data.SqlClient.SqlConnection. |
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
| 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. |