Class MSSqlExecutor
Inheritance
System.Object
MSSqlExecutor
Implements
System.IDisposable
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Assembly: Terrasoft.DB.MSSql.dll
Syntax
public class MSSqlExecutor : DBExecutor, IDisposable
Constructors
MSSqlExecutor(UserConnection)
Declaration
public MSSqlExecutor(UserConnection userConnection)
Parameters
MSSqlExecutor(UserConnection, QueryKind)
Declaration
public MSSqlExecutor(UserConnection userConnection, QueryKind queryKind)
Parameters
Type |
Name |
Description |
UserConnection |
userConnection |
|
QueryKind |
queryKind |
|
Properties
IsOffsetPagingFeatureEnabled
Declaration
protected override bool IsOffsetPagingFeatureEnabled { get; }
Property Value
Type |
Description |
System.Boolean |
|
Overrides
ServerVersion
Declaration
protected override Version ServerVersion { get; }
Property Value
Type |
Description |
System.Version |
|
Overrides
UseDaylightSavingTimeSupport
Declaration
protected override bool UseDaylightSavingTimeSupport { get; }
Property Value
Type |
Description |
System.Boolean |
|
Overrides
Methods
AddQueryParameterToSqlParameters(SqlParameterCollection, QueryParameter)
Declaration
protected void AddQueryParameterToSqlParameters(SqlParameterCollection sqlParameters, QueryParameter queryParameter)
Parameters
Type |
Name |
Description |
System.Data.SqlClient.SqlParameterCollection |
sqlParameters |
|
QueryParameter |
queryParameter |
|
BuildConnectionString(String, String)
Declaration
protected override string BuildConnectionString(string userName, string password)
Parameters
Type |
Name |
Description |
System.String |
userName |
|
System.String |
password |
|
Returns
Type |
Description |
System.String |
|
Overrides
DBParametersToQueryParameters(DbParameterCollection, QueryParameterCollection)
Declaration
protected override void DBParametersToQueryParameters(DbParameterCollection dbParameters, QueryParameterCollection queryParameters)
Parameters
Overrides
FailoverExecute<TResult>(DbCommand, Func<TResult>)
Declaration
protected override TResult FailoverExecute<TResult>(DbCommand command, Func<TResult> func)
Parameters
Type |
Name |
Description |
System.Data.Common.DbCommand |
command |
|
System.Func<TResult> |
func |
|
Returns
Type Parameters
Overrides
Terrasoft.Core.DB.DBExecutor.FailoverExecute<TResult>(System.Data.Common.DbCommand, System.Func<TResult>)
GetConnectionString(QueryKind)
Declaration
protected override string GetConnectionString(QueryKind kind)
Parameters
Type |
Name |
Description |
QueryKind |
kind |
|
Returns
Type |
Description |
System.String |
|
InitConnectionStrings()
Declaration
protected static void InitConnectionStrings()
InitilizeConnectionAfterOpen(DbConnection)
Declaration
protected override void InitilizeConnectionAfterOpen(DbConnection dbConnection)
Parameters
Type |
Name |
Description |
System.Data.Common.DbConnection |
dbConnection |
|
Overrides
NewCommand()
Declaration
protected override DbCommand NewCommand()
Returns
Type |
Description |
System.Data.Common.DbCommand |
|
Overrides
NewConnection()
Declaration
protected override DbConnection NewConnection()
Returns
Type |
Description |
System.Data.Common.DbConnection |
|
Overrides
QueryParametersToDBParameters(QueryParameterCollection, DbParameterCollection)
Declaration
protected override void QueryParametersToDBParameters(QueryParameterCollection queryParameters, DbParameterCollection dbParameters)
Parameters
Overrides
RefreshMaterializedView(String)
Declaration
public override void RefreshMaterializedView(string viewName)
Parameters
Type |
Name |
Description |
System.String |
viewName |
|
Overrides
SplitBatches(String)
Declaration
protected override IEnumerable<string> SplitBatches(string sqlText)
Parameters
Type |
Name |
Description |
System.String |
sqlText |
|
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<System.String> |
|
Overrides
ValidateBatches(DbCommand, String, out String)
Declaration
protected override bool ValidateBatches(DbCommand command, string sqlText, out string message)
Parameters
Type |
Name |
Description |
System.Data.Common.DbCommand |
command |
|
System.String |
sqlText |
|
System.String |
message |
|
Returns
Type |
Description |
System.Boolean |
|
Overrides
Implements
System.IDisposable
Extension Methods