SqlServerOrmLiteDialectProvider
Assembly: ServiceStack.OrmLite.SqlServer.Data.dll
View Source
Declaration
public class SqlServerOrmLiteDialectProvider : OrmLiteDialectProviderBase<SqlServerOrmLiteDialectProvider>, IOrmLiteDialectProvider
Properties
SqlRandom
View Source
Declaration
public override string SqlRandom { get; }
Fields
Instance
View Source
Declaration
public static SqlServerOrmLiteDialectProvider Instance
Methods
GetQuotedValue(String)
View Source
Declaration
public override string GetQuotedValue(string paramValue)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | paramValue |
CreateConnection(String, Dictionary<String, String>)
View Source
Declaration
public override IDbConnection CreateConnection(string connectionString, Dictionary<string, string> options)
Returns
IDbConnection
Parameters
| Type | Name |
|---|---|
System.String | connectionString |
Dictionary<System.String,System.String> | options |
SqlExpression<T>()
View Source
Declaration
public override SqlExpression<T> SqlExpression<T>()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Type Parameters
T
CreateParam()
View Source
Declaration
public override IDbDataParameter CreateParam()
Returns
IDbDataParameter
ToTableNamesStatement(String)
View Source
Declaration
public override string ToTableNamesStatement(string schema)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
ToTableNamesWithRowCountsStatement(Boolean, String)
View Source
Declaration
public override string ToTableNamesWithRowCountsStatement(bool live, string schema)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Boolean | live |
System.String | schema |
GetSchemas(IDbCommand)
View Source
Declaration
public override List<string> GetSchemas(IDbCommand dbCmd)
Returns
List<System.String>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
GetSchemaTables(IDbCommand)
View Source
Declaration
public override Dictionary<string, List<string>> GetSchemaTables(IDbCommand dbCmd)
Returns
Dictionary<System.String,List<System.String>>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
DoesSchemaExist(IDbCommand, String)
View Source
Declaration
public override bool DoesSchemaExist(IDbCommand dbCmd, string schemaName)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | schemaName |
DoesSchemaExistAsync(IDbCommand, String, CancellationToken)
View Source
Declaration
public override async Task<bool> DoesSchemaExistAsync(IDbCommand dbCmd, string schemaName, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | schemaName |
CancellationToken | token |
ToCreateSchemaStatement(String)
View Source
Declaration
public override string ToCreateSchemaStatement(string schemaName)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schemaName |
DoesTableExist(IDbCommand, String, String)
View Source
Declaration
public override bool DoesTableExist(IDbCommand dbCmd, string tableName, string schema = null)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | tableName |
System.String | schema |
DoesTableExistAsync(IDbCommand, String, String, CancellationToken)
View Source
Declaration
public override async Task<bool> DoesTableExistAsync(IDbCommand dbCmd, string tableName, string schema = null, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | tableName |
System.String | schema |
CancellationToken | token |
DoesColumnExist(IDbConnection, String, String, String)
View Source
Declaration
public override bool DoesColumnExist(IDbConnection db, string columnName, string tableName, string schema = null)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
System.String | columnName |
System.String | tableName |
System.String | schema |
DoesColumnExistAsync(IDbConnection, String, String, String, CancellationToken)
View Source
Declaration
public override async Task<bool> DoesColumnExistAsync(IDbConnection db, string columnName, string tableName, string schema = null, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
System.String | columnName |
System.String | tableName |
System.String | schema |
CancellationToken | token |
GetForeignKeyOnDeleteClause(ForeignKeyConstraint)
View Source
Declaration
public override string GetForeignKeyOnDeleteClause(ForeignKeyConstraint foreignKey)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ForeignKeyConstraint | foreignKey |
GetForeignKeyOnUpdateClause(ForeignKeyConstraint)
View Source
Declaration
public override string GetForeignKeyOnUpdateClause(ForeignKeyConstraint foreignKey)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ForeignKeyConstraint | foreignKey |
GetDropForeignKeyConstraints(ModelDefinition)
View Source
Declaration
public override string GetDropForeignKeyConstraints(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
ToAddColumnStatement(String, String, FieldDefinition)
View Source
Declaration
public override string ToAddColumnStatement(string schema, string table, FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
System.String | table |
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
ToAlterColumnStatement(String, String, FieldDefinition)
View Source
Declaration
public override string ToAlterColumnStatement(string schema, string table, FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
System.String | table |
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
ToChangeColumnNameStatement(String, String, FieldDefinition, String)
View Source
Declaration
public override string ToChangeColumnNameStatement(string schema, string table, FieldDefinition fieldDef, string oldColumn)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
System.String | table |
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
System.String | oldColumn |
ToRenameColumnStatement(String, String, String, String)
View Source
Declaration
public override string ToRenameColumnStatement(string schema, string table, string oldColumn, string newColumn)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
System.String | table |
System.String | oldColumn |
System.String | newColumn |
GetAutoIncrementDefinition(FieldDefinition)
View Source
Declaration
protected virtual string GetAutoIncrementDefinition(FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
GetAutoIdDefaultValue(FieldDefinition)
View Source
Declaration
public override string GetAutoIdDefaultValue(FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
GetColumnDefinition(FieldDefinition)
View Source
Declaration
public override string GetColumnDefinition(FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
ToInsertRowStatement(IDbCommand, Object, ICollection<String>)
View Source
Declaration
public override string ToInsertRowStatement(IDbCommand cmd, object objWithProperties, ICollection<string> insertFields = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
System.Object | objWithProperties |
ICollection<System.String> | insertFields |
Sequence(String, String)
View Source
Declaration
protected string Sequence(string schema, string sequence)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
System.String | sequence |
ShouldSkipInsert(FieldDefinition)
View Source
Declaration
protected override bool ShouldSkipInsert(FieldDefinition fieldDef)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
ShouldReturnOnInsert(ModelDefinition, FieldDefinition)
View Source
Declaration
protected virtual bool ShouldReturnOnInsert(ModelDefinition modelDef, FieldDefinition fieldDef)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
HasInsertReturnValues(ModelDefinition)
View Source
Declaration
public override bool HasInsertReturnValues(ModelDefinition modelDef)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
SupportsSequences(FieldDefinition)
View Source
Declaration
protected virtual bool SupportsSequences(FieldDefinition fieldDef)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
EnableIdentityInsert<T>(IDbCommand)
View Source
Declaration
public override void EnableIdentityInsert<T>(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
Type Parameters
T
EnableIdentityInsertAsync<T>(IDbCommand, CancellationToken)
View Source
Declaration
public override Task EnableIdentityInsertAsync<T>(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
Type Parameters
T
DisableIdentityInsert<T>(IDbCommand)
View Source
Declaration
public override void DisableIdentityInsert<T>(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
Type Parameters
T
DisableIdentityInsertAsync<T>(IDbCommand, CancellationToken)
View Source
Declaration
public override Task DisableIdentityInsertAsync<T>(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
Type Parameters
T
PrepareParameterizedInsertStatement<T>(IDbCommand, ICollection<String>, Func<FieldDefinition, Boolean>)
View Source
Declaration
public override void PrepareParameterizedInsertStatement<T>(IDbCommand cmd, ICollection<string> insertFields = null, Func<FieldDefinition, bool> shouldInclude = null)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
ICollection<System.String> | insertFields |
Func<ServiceStack.OrmLite.FieldDefinition,System.Boolean> | shouldInclude |
Type Parameters
T
PrepareInsertRowStatement<T>(IDbCommand, Dictionary<String, Object>)
View Source
Declaration
public override void PrepareInsertRowStatement<T>(IDbCommand dbCmd, Dictionary<string, object> args)
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
Dictionary<System.String,System.Object> | args |
Type Parameters
T
ToSelectStatement(QueryType, ModelDefinition, String, String, String, Nullable<Int32>, Nullable<Int32>, ISet<String>)
View Source
Declaration
public override string ToSelectStatement(QueryType queryType, ModelDefinition modelDef, string selectExpression, string bodyExpression, string orderByExpression = null, int? offset = null, int? rows = null, ISet<string> tags = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.QueryType | queryType |
| ServiceStack.OrmLite.ModelDefinition | modelDef |
System.String | selectExpression |
System.String | bodyExpression |
System.String | orderByExpression |
System.Nullable<System.Int32> | offset |
System.Nullable<System.Int32> | rows |
ISet<System.String> | tags |
SqlTop(String, Int32, String)
View Source
Declaration
protected static string SqlTop(string sql, int take, string selectType = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | sql |
System.Int32 | take |
System.String | selectType |
UseAliasesOrStripTablePrefixes(String)
View Source
Declaration
public static string UseAliasesOrStripTablePrefixes(string selectExpression)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | selectExpression |
GetLoadChildrenSubSelect<From>(SqlExpression<From>)
View Source
Declaration
public override string GetLoadChildrenSubSelect<From>(SqlExpression<From> expr)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.SqlExpression<T> | expr |
Type Parameters
From
SqlCurrency(String, String)
View Source
Declaration
public override string SqlCurrency(string fieldOrValue, string currencySymbol)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | fieldOrValue |
System.String | currencySymbol |
SqlBool(Boolean)
View Source
Declaration
public override string SqlBool(bool value)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Boolean | value |
SqlLimit(Nullable<Int32>, Nullable<Int32>)
View Source
Declaration
public override string SqlLimit(int? offset = null, int? rows = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Nullable<System.Int32> | offset |
System.Nullable<System.Int32> | rows |
SqlCast(Object, String)
View Source
Declaration
public override string SqlCast(object fieldOrValue, string castAs)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Object | fieldOrValue |
System.String | castAs |
EnableForeignKeysCheck(IDbCommand)
View Source
Declaration
public override void EnableForeignKeysCheck(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
EnableForeignKeysCheckAsync(IDbCommand, CancellationToken)
View Source
Declaration
public override Task EnableForeignKeysCheckAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
DisableForeignKeysCheck(IDbCommand)
View Source
Declaration
public override void DisableForeignKeysCheck(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
DisableForeignKeysCheckAsync(IDbCommand, CancellationToken)
View Source
Declaration
public override Task DisableForeignKeysCheckAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
Unwrap(IDbConnection)
View Source
Declaration
protected DbConnection Unwrap(IDbConnection db)
Returns
DbConnection
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
Unwrap(IDbCommand)
View Source
Declaration
protected DbCommand Unwrap(IDbCommand cmd)
Returns
DbCommand
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
Unwrap(IDataReader)
View Source
Declaration
protected DbDataReader Unwrap(IDataReader reader)
Returns
DbDataReader
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
OpenAsync(IDbConnection, CancellationToken)
View Source
Declaration
public override Task OpenAsync(IDbConnection db, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
CancellationToken | token |
ExecuteReaderAsync(IDbCommand, CancellationToken)
View Source
Declaration
public override Task<IDataReader> ExecuteReaderAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task<IDataReader>
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
ExecuteNonQueryAsync(IDbCommand, CancellationToken)
View Source
Declaration
public override Task<int> ExecuteNonQueryAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task<System.Int32>
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
ExecuteScalarAsync(IDbCommand, CancellationToken)
View Source
Declaration
public override Task<object> ExecuteScalarAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task<System.Object>
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
ReadAsync(IDataReader, CancellationToken)
View Source
Declaration
public override Task<bool> ReadAsync(IDataReader reader, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
CancellationToken | token |
ReaderEach<T>(IDataReader, Func<T>, CancellationToken)
View Source
Declaration
public override async Task<List<T>> ReaderEach<T>(IDataReader reader, Func<T> fn, CancellationToken token = null)
Returns
Task<List<<T>>>
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
Func<<T>> | fn |
CancellationToken | token |
Type Parameters
T
ReaderEach<Return>(IDataReader, Action, Return, CancellationToken)
View Source
Declaration
public override async Task<Return> ReaderEach<Return>(IDataReader reader, Action fn, Return source, CancellationToken token = null)
Returns
Task<<Return>>
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
Action | fn |
<Return> | source |
CancellationToken | token |
Type Parameters
Return
ReaderRead<T>(IDataReader, Func<T>, CancellationToken)
View Source
Declaration
public override async Task<T> ReaderRead<T>(IDataReader reader, Func<T> fn, CancellationToken token = null)
Returns
Task<<T>>
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
Func<<T>> | fn |
CancellationToken | token |
Type Parameters
T
InitConnection(IDbConnection)
View Source
Declaration
public override void InitConnection(IDbConnection dbConn)
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |