Class SqlProviderMsSql

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

SqlProvider for Microsoft SQL Server databases.

public class SqlProviderMsSql : SqlProvider

Inheritance

object

SqlProvider

SqlProviderMsSql

Inherited Members

SqlProvider.GlobalPrefix

SqlProvider.ReplaceDecimalPlaceholders(string)

SqlProvider.CreateParamMap(SqlParams)

SqlProvider.FindParam(Dictionary<string, SqlParam>, string, string)

SqlProvider.GetNativeParameterName(string)

SqlProvider.GetSqlParameterToken(string)

SqlProvider.CreateDbParameter(DbCommand, SqlParam)

SqlProvider.PrepareCommand(DbCommand, string, SqlParams)

SqlProvider.DecimalWithArgsSql(string)

SqlProvider.Log(Exception, string, object[], MemTable)

SqlProvider.FormatSqlLogValue(object)

SqlProvider.FormatSqlParameters(DbParameterCollection)

SqlProvider.CanLogSql(string)

SqlProvider.LogSql(DbCommand)

SqlProvider.CreateSqlParams(string, params object[])

SqlProvider.WaitUntilDatabaseReady(string, int, int)

SqlProvider.ReplaceDataTypePlaceholders(string)

SqlProvider.CreateConnectionStringBuilder(string)

SqlProvider.GetDatabaseName(string)

SqlProvider.CreateConnection(string)

SqlProvider.CreateCommand(DbConnection, string, params object[])

SqlProvider.CreateCommand(DbConnection, string, SqlParams)

SqlProvider.CanConnect(string, bool)

SqlProvider.DatabaseExists(string)

SqlProvider.EnsureConnection(string)

SqlProvider.OpenConnection(DbConnectionInfo)

SqlProvider.OpenConnection(string)

SqlProvider.BeginTransactionContext(DbConnectionInfo)

SqlProvider.BeginTransactionContext(string)

SqlProvider.NormalizeConnectionString(string)

SqlProvider.CreateConnectionString(string, string, string, string)

SqlProvider.Select(DbConnectionInfo, string)

SqlProvider.Select(DbConnectionInfo, string, params object[])

SqlProvider.Select(string, string)

SqlProvider.Select(string, string, params object[])

SqlProvider.Select(string, string, int, params object[])

SqlProvider.Select(DbTransaction, string, int, params object[])

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string)

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, int, params object[])

SqlProvider.SelectTo(DbTransaction, MemTable, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, string)

SqlProvider.ExecSql(DbConnectionInfo, string, params object[])

SqlProvider.ExecSql(string, string)

SqlProvider.ExecSql(string, string, params object[])

SqlProvider.ExecSql(string, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, IEnumerable<string>)

SqlProvider.ExecSql(string, IEnumerable<string>)

SqlProvider.ExecSql(DbTransaction, string)

SqlProvider.ExecSql(DbTransaction, string, params object[])

SqlProvider.ExecSql(DbTransaction, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, Action<DbTransaction>)

SqlProvider.ExecSql(string, Action<DbTransaction>)

SqlProvider.SelectResults(string, string)

SqlProvider.SelectResults(string, string, params object[])

SqlProvider.SelectResults(DbTransaction, string, int, params object[])

SqlProvider.SelectResult(string, string)

SqlProvider.SelectResult(string, string, object)

SqlProvider.SelectResult(string, string, object, params object[])

SqlProvider.SelectResult(DbTransaction, string, int, object, params object[])

SqlProvider.IntegerResult(string, string, int)

SqlProvider.IntegerResult(string, string, int, params object[])

SqlProvider.IntegerResult(DbTransaction, string, int, int, params object[])

SqlProvider.SelectForUpdate(DbTransaction, string, string, object)

SqlProvider.SelectForUpdate(DbTransaction, string, string, int, object)

SqlProvider.SelectIncrementLocked(DbConnectionInfo, string, string, object, string)

SqlProvider.SelectIncrementLocked(string, string, string, object, string, int)

SqlProvider.SelectIncrementLocked(DbTransaction, string, string, object, string, int)

SqlProvider.NormalizeRowLimit(int)

SqlProvider.QuoteName(string)

SqlProvider.GetServerDateTime(DbConnectionInfo)

SqlProvider.QSDate(DateTime)

SqlProvider.QSDateTime(DateTime)

SqlProvider.SupportsAlterTableType(AlterTableType)

SqlProvider.AddColumnSql(string, string)

SqlProvider.DropColumnSql(string, string)

SqlProvider.SetDefaultBeforeNotNullUpdateSql(string, string, string, bool)

SqlProvider.AddUniqueConstraintSql(string, string, string)

SqlProvider.DropUniqueConstraintSql(string, string)

SqlProvider.AddForeignKeySql(string, string, string, string, string)

SqlProvider.DropForeignKeySql(string, string)

SqlProvider.GeneratorExists(string, string)

SqlProvider.CreateGenerator(string, string)

SqlProvider.SetGeneratorTo(string, string, int)

SqlProvider.NextIdByGenerator(DbTransaction, string)

SqlProvider.Name

SqlProvider.Factory

SqlProvider.ServerType

SqlProvider.ConnectionStringAdapter

SqlProvider.PositionalParameters

SqlProvider.ConnectionStringTemplate

SqlProvider.SupportsTransactions

SqlProvider.SupportedAlterTableTypes

SqlProvider.PrimaryKeySql

SqlProvider.NotNullSql

SqlProvider.NullSql

SqlProvider.DefaultCommandTimeoutSeconds

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

TypeExtensions.InheritsFrom(object, Type)

Properties

AutoIncSql

Keyword, used in replacing a placeholder

public override string AutoIncSql { get; }

Property Value

string

BlobSql

Keyword, used in replacing a placeholder

public override string BlobSql { get; }

Property Value

string

BlobTextSql

Keyword, used in replacing a placeholder

public override string BlobTextSql { get; }

Property Value

string

BoolSql

Keyword, used in replacing a placeholder

public override string BoolSql { get; }

Property Value

string

CanCreateDatabases

True if this provider can create databases.

public override bool CanCreateDatabases { get; }

Property Value

bool

DatabaseKeys

A list of strings used as database name key in connection strings.

public override string[] DatabaseKeys { get; }

Property Value

string[]

DateSql

Keyword, used in replacing a placeholder

public override string DateSql { get; }

Property Value

string

DateTimeSql

Keyword, used in replacing a placeholder

public override string DateTimeSql { get; }

Property Value

string

DecimalSql

Keyword, used in replacing a placeholder

public override string DecimalSql { get; }

Property Value

string

Description

A description of this provider.

public override string Description { get; }

Property Value

string

FloatSql

Keyword, used in replacing a placeholder

public override string FloatSql { get; }

Property Value

string

LastIdSql

The keyword that can be used to return the last inserted id in an SQL statement.

public override string LastIdSql { get; }

Property Value

string

NBlobTextSql

Keyword, used in replacing a placeholder

public override string NBlobTextSql { get; }

Property Value

string

NVarcharSql

Keyword, used in replacing a placeholder

public override string NVarcharSql { get; }

Property Value

string

NativePrefix

The prefix used for native parameters.

public override string NativePrefix { get; }

Property Value

string

ObjectEndDelimiter

The delimiter used to quote object names.

public override string ObjectEndDelimiter { get; }

Property Value

string

ObjectStartDelimiter

The delimiter used to quote object names.

public override string ObjectStartDelimiter { get; }

Property Value

string

OidMode

The OidMode.

public override OidMode OidMode { get; }

Property Value

OidMode

PasswordKeys

A list of strings used as password key in connection strings.

public override string[] PasswordKeys { get; }

Property Value

string[]

ServerDateTimeSql

The keyword that can be used to return the current datetime in an SQL statement.

public override string ServerDateTimeSql { get; }

Property Value

string

ServerKeys

A list of strings used as server name key in connection strings.

public override string[] ServerKeys { get; }

Property Value

string[]

SuperUser

The super user name.

public override string SuperUser { get; }

Property Value

string

SuperUserPassword

The super user password.

public override string SuperUserPassword { get; }

Property Value

string

SupportsAutoIncFields

True if this provider supports auto-increment fields.

public override bool SupportsAutoIncFields { get; }

Property Value

bool

SupportsGenerators

True if this provider supports generators.

public override bool SupportsGenerators { get; }

Property Value

bool

UserNameKeys

A list of strings used as user name key in connection strings.

public override string[] UserNameKeys { get; }

Property Value

string[]

VarcharSql

Keyword, used in replacing a placeholder

public override string VarcharSql { get; }

Property Value

string

Methods

ApplyRowLimit(string, int)

Applies a row limit to the SqlText SELECT statement.

public override string ApplyRowLimit(string SqlText, int RowLimit)

Parameters

SqlText string

RowLimit int

Returns

string

Concat(params string[])

Concatenates two or more strings.

Example: SELECT FirstName || LastName As FullName FROM Customers

Oracle, Firebird, SQLite: ||

MsSql, Access : +

public override string Concat(params string[] Parts)

Parameters

Parts string[]

Returns

string

CreateDatabase(string)

Creates a database.

public override bool CreateDatabase(string ConnectionString)

Parameters

ConnectionString string

Returns

bool

DropColumnDefaultSql(string, string)

Returns an "alter column" SQL statement.

public override string DropColumnDefaultSql(string TableName, string ColumnName)

Parameters

TableName string

ColumnName string

Returns

string

DropNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string DropNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string

GetServerDateTime(string)

Returns the current date and time of the database server

public override DateTime GetServerDateTime(string ConnectionString)

Parameters

ConnectionString string

Returns

DateTime

LastId(DbTransaction, string)

Returns the last id produced by an INSERT Sqlt statement.

It should be used only with databases that support identity (auto-increment) columns

public override int LastId(DbTransaction Transaction, string TableName)

Parameters

Transaction DbTransaction

TableName string

Returns

int

RenameColumnSql(string, string, string)

Returns an "alter column" SQL statement.

public override string RenameColumnSql(string TableName, string ColumnName, string NewColumnName)

Parameters

TableName string

ColumnName string

NewColumnName string

Returns

string

SelectForUpdateSql(string, string)

Returns a SELECT statement that locks a single row for update.

public override string SelectForUpdateSql(string TableName, string FieldName)

Parameters

TableName string

FieldName string

Returns

string

SetColumnDefaultSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnDefaultSql(string TableName, string ColumnName, string DefaultExpression)

Parameters

TableName string

ColumnName string

DefaultExpression string

Returns

string

SetColumnLengthSql(string, string, string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnLengthSql(string TableName, string ColumnName, string DataType, string Required, string DefaultExpression)

Parameters

TableName string

ColumnName string

DataType string

Required string

DefaultExpression string

Returns

string

SetNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string

SetTableGeneratorTo(string, string, int)

Attempts to set a generator/sequencer or identity column to Value.

VERY DANGEROOUS.

public override void SetTableGeneratorTo(string ConnectionString, string TableName, int Value)

Parameters

ConnectionString string

TableName string

Value int