IOrmLiteDialectProvider
Assembly: ServiceStack.OrmLite.dll
View Source
Declaration
public interface IOrmLiteDialectProvider
Properties
OnOpenConnection
Custom delegate invoked when a DB Connection is opened
View Source
Declaration
Action<IDbConnection> OnOpenConnection { get; set; }
ExecFilter
View Source
Declaration
IOrmLiteExecFilter ExecFilter { get; set; }
ParamString
View Source
Declaration
string ParamString { get; set; }
NamingStrategy
View Source
Declaration
INamingStrategy NamingStrategy { get; set; }
StringSerializer
View Source
Declaration
IStringSerializer StringSerializer { get; set; }
ParamNameFilter
View Source
Declaration
Func<string, string> ParamNameFilter { get; set; }
Variables
View Source
Declaration
Dictionary<string, string> Variables { get; }
SqlRandom
View Source
Declaration
string SqlRandom { get; }
Methods
RegisterConverter<T>(IOrmLiteConverter)
View Source
Declaration
void RegisterConverter<T>(IOrmLiteConverter converter)
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.IOrmLiteConverter | converter |
Type Parameters
T
InitConnection(IDbConnection)
Invoked when a DB Connection is opened
View Source
Declaration
void InitConnection(IDbConnection dbConn)
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
GetConverter(Type)
Gets the explicit Converter registered for a specific type
View Source
Declaration
IOrmLiteConverter GetConverter(Type type)
Returns
ServiceStack.OrmLite.IOrmLiteConverter
Parameters
| Type | Name |
|---|---|
Type | type |
GetConverterBestMatch(Type)
Return best matching converter, falling back to Enum, Value or Ref Type Converters
View Source
Declaration
IOrmLiteConverter GetConverterBestMatch(Type type)
Returns
ServiceStack.OrmLite.IOrmLiteConverter
Parameters
| Type | Name |
|---|---|
Type | type |
GetConverterBestMatch(FieldDefinition)
View Source
Declaration
IOrmLiteConverter GetConverterBestMatch(FieldDefinition fieldDef)
Returns
ServiceStack.OrmLite.IOrmLiteConverter
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
EscapeWildcards(String)
View Source
Declaration
string EscapeWildcards(string value)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | value |
GetQuotedValue(String)
Quote the string so that it can be used inside an SQL-expression Escape quotes inside the string
View Source
Declaration
string GetQuotedValue(string paramValue)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | paramValue |
GetQuotedValue(Object, Type)
View Source
Declaration
string GetQuotedValue(object value, Type fieldType)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Object | value |
Type | fieldType |
GetDefaultValue(Type, String)
View Source
Declaration
string GetDefaultValue(Type tableType, string fieldName)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Type | tableType |
System.String | fieldName |
GetDefaultValue(FieldDefinition)
View Source
Declaration
string GetDefaultValue(FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
HasInsertReturnValues(ModelDefinition)
View Source
Declaration
bool HasInsertReturnValues(ModelDefinition modelDef)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
GetParamValue(Object, Type)
View Source
Declaration
object GetParamValue(object value, Type fieldType)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
System.Object | value |
Type | fieldType |
InitQueryParam(IDbDataParameter)
View Source
Declaration
void InitQueryParam(IDbDataParameter param)
Parameters
| Type | Name |
|---|---|
IDbDataParameter | param |
InitUpdateParam(IDbDataParameter)
View Source
Declaration
void InitUpdateParam(IDbDataParameter param)
Parameters
| Type | Name |
|---|---|
IDbDataParameter | param |
ToDbValue(Object, Type)
View Source
Declaration
object ToDbValue(object value, Type type)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
System.Object | value |
Type | type |
FromDbValue(Object, Type)
View Source
Declaration
object FromDbValue(object value, Type type)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
System.Object | value |
Type | type |
GetValue(IDataReader, Int32, Type)
View Source
Declaration
object GetValue(IDataReader reader, int columnIndex, Type type)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
System.Int32 | columnIndex |
Type | type |
GetValues(IDataReader, Object[])
View Source
Declaration
int GetValues(IDataReader reader, object[] values)
Returns
System.Int32
Parameters
| Type | Name |
|---|---|
IDataReader | reader |
System.Object[] | values |
CreateConnection(String, Dictionary<String, String>)
View Source
Declaration
IDbConnection CreateConnection(string filePath, Dictionary<string, string> options)
Returns
IDbConnection
Parameters
| Type | Name |
|---|---|
System.String | filePath |
Dictionary<System.String,System.String> | options |
GetTableName(ModelDefinition)
View Source
Declaration
string GetTableName(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
GetTableName(ModelDefinition, Boolean)
View Source
Declaration
string GetTableName(ModelDefinition modelDef, bool useStrategy)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
System.Boolean | useStrategy |
GetTableName(String, String)
View Source
Declaration
string GetTableName(string table, string schema = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | table |
System.String | schema |
GetTableName(String, String, Boolean)
View Source
Declaration
string GetTableName(string table, string schema, bool useStrategy)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | table |
System.String | schema |
System.Boolean | useStrategy |
GetQuotedTableName(ModelDefinition)
View Source
Declaration
string GetQuotedTableName(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
GetQuotedTableName(String, String)
View Source
Declaration
string GetQuotedTableName(string tableName, string schema = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | tableName |
System.String | schema |
GetQuotedTableName(String, String, Boolean)
View Source
Declaration
string GetQuotedTableName(string tableName, string schema, bool useStrategy)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | tableName |
System.String | schema |
System.Boolean | useStrategy |
GetQuotedColumnName(String)
View Source
Declaration
string GetQuotedColumnName(string columnName)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | columnName |
GetQuotedName(String)
View Source
Declaration
string GetQuotedName(string name)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | name |
GetQuotedName(String, String)
View Source
Declaration
string GetQuotedName(string name, string schema)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | name |
System.String | schema |
SanitizeFieldNameForParamName(String)
View Source
Declaration
string SanitizeFieldNameForParamName(string fieldName)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | fieldName |
GetColumnDefinition(FieldDefinition)
View Source
Declaration
string GetColumnDefinition(FieldDefinition fieldDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
GetLastInsertId(IDbCommand)
View Source
Declaration
long GetLastInsertId(IDbCommand command)
Returns
System.Int64
Parameters
| Type | Name |
|---|---|
IDbCommand | command |
GetLastInsertIdSqlSuffix<T>()
View Source
Declaration
string GetLastInsertIdSqlSuffix<T>()
Returns
System.String
Type Parameters
T
ToSelectStatement(Type, String, Object[])
View Source
Declaration
string ToSelectStatement(Type tableType, string sqlFilter, params object[] filterParams)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Type | tableType |
System.String | sqlFilter |
System.Object[] | filterParams |
ToSelectStatement(QueryType, ModelDefinition, String, String, String, Nullable<Int32>, Nullable<Int32>, ISet<String>)
View Source
Declaration
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 |
ToInsertRowStatement(IDbCommand, Object, ICollection<String>)
View Source
Declaration
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 |
PrepareParameterizedInsertStatement<T>(IDbCommand, ICollection<String>, Func<FieldDefinition, Boolean>)
View Source
Declaration
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
PrepareParameterizedUpdateStatement<T>(IDbCommand, ICollection<String>)
View Source
Declaration
bool PrepareParameterizedUpdateStatement<T>(IDbCommand cmd, ICollection<string> updateFields = null)
Returns
System.Boolean: If had RowVersion
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
ICollection<System.String> | updateFields |
Type Parameters
T
PrepareParameterizedDeleteStatement<T>(IDbCommand, IDictionary<String, Object>)
View Source
Declaration
bool PrepareParameterizedDeleteStatement<T>(IDbCommand cmd, IDictionary<string, object> deleteFieldValues)
Returns
System.Boolean: If had RowVersion
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
IDictionary<System.String,System.Object> | deleteFieldValues |
Type Parameters
T
PrepareStoredProcedureStatement<T>(IDbCommand, T)
View Source
Declaration
void PrepareStoredProcedureStatement<T>(IDbCommand cmd, T obj)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
<T> | obj |
Type Parameters
T
SetParameterValues<T>(IDbCommand, Object)
View Source
Declaration
void SetParameterValues<T>(IDbCommand dbCmd, object obj)
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.Object | obj |
Type Parameters
T
SetParameter(FieldDefinition, IDbDataParameter)
View Source
Declaration
void SetParameter(FieldDefinition fieldDef, IDbDataParameter p)
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
IDbDataParameter | p |
EnableIdentityInsert<T>(IDbCommand)
View Source
Declaration
void EnableIdentityInsert<T>(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
Type Parameters
T
EnableIdentityInsertAsync<T>(IDbCommand, CancellationToken)
View Source
Declaration
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
void DisableIdentityInsert<T>(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
Type Parameters
T
DisableIdentityInsertAsync<T>(IDbCommand, CancellationToken)
View Source
Declaration
Task DisableIdentityInsertAsync<T>(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
Type Parameters
T
EnableForeignKeysCheck(IDbCommand)
View Source
Declaration
void EnableForeignKeysCheck(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
EnableForeignKeysCheckAsync(IDbCommand, CancellationToken)
View Source
Declaration
Task EnableForeignKeysCheckAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
DisableForeignKeysCheck(IDbCommand)
View Source
Declaration
void DisableForeignKeysCheck(IDbCommand cmd)
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
DisableForeignKeysCheckAsync(IDbCommand, CancellationToken)
View Source
Declaration
Task DisableForeignKeysCheckAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
GetFieldDefinitionMap(ModelDefinition)
View Source
Declaration
Dictionary<string, FieldDefinition> GetFieldDefinitionMap(ModelDefinition modelDef)
Returns
Dictionary<System.String,ServiceStack.OrmLite.FieldDefinition>
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
GetFieldValue(FieldDefinition, Object)
View Source
Declaration
object GetFieldValue(FieldDefinition fieldDef, object value)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
System.Object | value |
GetFieldValue(Type, Object)
View Source
Declaration
object GetFieldValue(Type fieldType, object value)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
Type | fieldType |
System.Object | value |
PrepareUpdateRowStatement(IDbCommand, Object, ICollection<String>)
View Source
Declaration
void PrepareUpdateRowStatement(IDbCommand dbCmd, object objWithProperties, ICollection<string> updateFields = null)
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.Object | objWithProperties |
ICollection<System.String> | updateFields |
PrepareUpdateRowStatement<T>(IDbCommand, Dictionary<String, Object>, String)
View Source
Declaration
void PrepareUpdateRowStatement<T>(IDbCommand dbCmd, Dictionary<string, object> args, string sqlFilter)
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
Dictionary<System.String,System.Object> | args |
System.String | sqlFilter |
Type Parameters
T
PrepareUpdateRowAddStatement<T>(IDbCommand, Dictionary<String, Object>, String)
View Source
Declaration
void PrepareUpdateRowAddStatement<T>(IDbCommand dbCmd, Dictionary<string, object> args, string sqlFilter)
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
Dictionary<System.String,System.Object> | args |
System.String | sqlFilter |
Type Parameters
T
PrepareInsertRowStatement<T>(IDbCommand, Dictionary<String, Object>)
View Source
Declaration
void PrepareInsertRowStatement<T>(IDbCommand dbCmd, Dictionary<string, object> args)
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
Dictionary<System.String,System.Object> | args |
Type Parameters
T
ToDeleteStatement(Type, String, Object[])
View Source
Declaration
string ToDeleteStatement(Type tableType, string sqlFilter, params object[] filterParams)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Type | tableType |
System.String | sqlFilter |
System.Object[] | filterParams |
CreateParameterizedDeleteStatement(IDbConnection, Object)
View Source
Declaration
IDbCommand CreateParameterizedDeleteStatement(IDbConnection connection, object objWithProperties)
Returns
IDbCommand
Parameters
| Type | Name |
|---|---|
IDbConnection | connection |
System.Object | objWithProperties |
ToExistStatement(Type, Object, String, Object[])
View Source
Declaration
string ToExistStatement(Type fromTableType, object objWithProperties, string sqlFilter, params object[] filterParams)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Type | fromTableType |
System.Object | objWithProperties |
System.String | sqlFilter |
System.Object[] | filterParams |
ToSelectFromProcedureStatement(Object, Type, String, Object[])
View Source
Declaration
string ToSelectFromProcedureStatement(object fromObjWithProperties, Type outputModelType, string sqlFilter, params object[] filterParams)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Object | fromObjWithProperties |
Type | outputModelType |
System.String | sqlFilter |
System.Object[] | filterParams |
ToExecuteProcedureStatement(Object)
View Source
Declaration
string ToExecuteProcedureStatement(object objWithProperties)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Object | objWithProperties |
ToCreateSchemaStatement(String)
View Source
Declaration
string ToCreateSchemaStatement(string schema)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
ToCreateTableStatement(Type)
View Source
Declaration
string ToCreateTableStatement(Type tableType)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Type | tableType |
ToPostCreateTableStatement(ModelDefinition)
View Source
Declaration
string ToPostCreateTableStatement(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
ToPostDropTableStatement(ModelDefinition)
View Source
Declaration
string ToPostDropTableStatement(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
ToCreateIndexStatements(Type)
View Source
Declaration
List<string> ToCreateIndexStatements(Type tableType)
Returns
List<System.String>
Parameters
| Type | Name |
|---|---|
Type | tableType |
ToCreateSequenceStatements(Type)
View Source
Declaration
List<string> ToCreateSequenceStatements(Type tableType)
Returns
List<System.String>
Parameters
| Type | Name |
|---|---|
Type | tableType |
ToCreateSequenceStatement(Type, String)
View Source
Declaration
string ToCreateSequenceStatement(Type tableType, string sequenceName)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Type | tableType |
System.String | sequenceName |
SequenceList(Type)
View Source
Declaration
List<string> SequenceList(Type tableType)
Returns
List<System.String>
Parameters
| Type | Name |
|---|---|
Type | tableType |
SequenceListAsync(Type, CancellationToken)
View Source
Declaration
Task<List<string>> SequenceListAsync(Type tableType, CancellationToken token = null)
Returns
Task<List<System.String>>
Parameters
| Type | Name |
|---|---|
Type | tableType |
CancellationToken | token |
GetSchemas(IDbCommand)
View Source
Declaration
List<string> GetSchemas(IDbCommand dbCmd)
Returns
List<System.String>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
GetSchemaTables(IDbCommand)
View Source
Declaration
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
bool DoesSchemaExist(IDbCommand dbCmd, string schema)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | schema |
DoesSchemaExistAsync(IDbCommand, String, CancellationToken)
View Source
Declaration
Task<bool> DoesSchemaExistAsync(IDbCommand dbCmd, string schema, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | schema |
CancellationToken | token |
DoesTableExist(IDbConnection, String, String)
View Source
Declaration
bool DoesTableExist(IDbConnection db, string tableName, string schema = null)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
System.String | tableName |
System.String | schema |
DoesTableExistAsync(IDbConnection, String, String, CancellationToken)
View Source
Declaration
Task<bool> DoesTableExistAsync(IDbConnection db, string tableName, string schema = null, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
System.String | tableName |
System.String | schema |
CancellationToken | token |
DoesTableExist(IDbCommand, String, String)
View Source
Declaration
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
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
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
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 |
DoesSequenceExist(IDbCommand, String)
View Source
Declaration
bool DoesSequenceExist(IDbCommand dbCmd, string sequence)
Returns
System.Boolean
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | sequence |
DoesSequenceExistAsync(IDbCommand, String, CancellationToken)
View Source
Declaration
Task<bool> DoesSequenceExistAsync(IDbCommand dbCmd, string sequenceName, CancellationToken token = null)
Returns
Task<System.Boolean>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
System.String | sequenceName |
CancellationToken | token |
FromDbRowVersion(Type, Object)
View Source
Declaration
object FromDbRowVersion(Type fieldType, object value)
Returns
System.Object
Parameters
| Type | Name |
|---|---|
Type | fieldType |
System.Object | value |
GetRowVersionSelectColumn(FieldDefinition, String)
View Source
Declaration
SelectItem GetRowVersionSelectColumn(FieldDefinition field, string tablePrefix = null)
Returns
ServiceStack.OrmLite.SelectItem
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | field |
System.String | tablePrefix |
GetRowVersionColumn(FieldDefinition, String)
View Source
Declaration
string GetRowVersionColumn(FieldDefinition field, string tablePrefix = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.FieldDefinition | field |
System.String | tablePrefix |
GetColumnNames(ModelDefinition)
View Source
Declaration
string GetColumnNames(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
GetColumnNames(ModelDefinition, String)
View Source
Declaration
SelectItem[] GetColumnNames(ModelDefinition modelDef, string tablePrefix)
Returns
ServiceStack.OrmLite.SelectItem[]
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
System.String | tablePrefix |
SqlExpression<T>()
View Source
Declaration
SqlExpression<T> SqlExpression<T>()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Type Parameters
T
CreateParam()
View Source
Declaration
IDbDataParameter CreateParam()
Returns
IDbDataParameter
GetDropForeignKeyConstraints(ModelDefinition)
View Source
Declaration
string GetDropForeignKeyConstraints(ModelDefinition modelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.ModelDefinition | modelDef |
ToAddColumnStatement(String, String, FieldDefinition)
View Source
Declaration
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
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
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
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 |
ToDropColumnStatement(String, String, String)
View Source
Declaration
string ToDropColumnStatement(string schema, string table, string column)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
System.String | table |
System.String | column |
ToAddForeignKeyStatement<T, TForeign>(Expression<Func<T, Object>>, Expression<Func<TForeign, Object>>, OnFkOption, OnFkOption, String)
View Source
Declaration
string ToAddForeignKeyStatement<T, TForeign>(Expression<Func<T, object>> field, Expression<Func<TForeign, object>> foreignField, OnFkOption onUpdate, OnFkOption onDelete, string foreignKeyName = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Expression<Func<<T>,System.Object>> | field |
Expression<Func<<TForeign>,System.Object>> | foreignField |
| ServiceStack.OrmLite.OnFkOption | onUpdate |
| ServiceStack.OrmLite.OnFkOption | onDelete |
System.String | foreignKeyName |
Type Parameters
TTForeign
ToCreateIndexStatement<T>(Expression<Func<T, Object>>, String, Boolean)
View Source
Declaration
string ToCreateIndexStatement<T>(Expression<Func<T, object>> field, string indexName = null, bool unique = false)
Returns
System.String
Parameters
| Type | Name |
|---|---|
Expression<Func<<T>,System.Object>> | field |
System.String | indexName |
System.Boolean | unique |
Type Parameters
T
OpenAsync(IDbConnection, CancellationToken)
View Source
Declaration
Task OpenAsync(IDbConnection db, CancellationToken token = null)
Returns
Task
Parameters
| Type | Name |
|---|---|
IDbConnection | db |
CancellationToken | token |
ExecuteReaderAsync(IDbCommand, CancellationToken)
View Source
Declaration
Task<IDataReader> ExecuteReaderAsync(IDbCommand cmd, CancellationToken token = null)
Returns
Task<IDataReader>
Parameters
| Type | Name |
|---|---|
IDbCommand | cmd |
CancellationToken | token |
ExecuteNonQueryAsync(IDbCommand, CancellationToken)
View Source
Declaration
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
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
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
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
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
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
InsertAndGetLastInsertIdAsync<T>(IDbCommand, CancellationToken)
View Source
Declaration
Task<long> InsertAndGetLastInsertIdAsync<T>(IDbCommand dbCmd, CancellationToken token)
Returns
Task<System.Int64>
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
CancellationToken | token |
Type Parameters
T
GetLoadChildrenSubSelect<From>(SqlExpression<From>)
View Source
Declaration
string GetLoadChildrenSubSelect<From>(SqlExpression<From> expr)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.SqlExpression<T> | expr |
Type Parameters
From
ToRowCountStatement(String)
View Source
Declaration
string ToRowCountStatement(string innerSql)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | innerSql |
ToUpdateStatement<T>(IDbCommand, T, ICollection<String>)
View Source
Declaration
string ToUpdateStatement<T>(IDbCommand dbCmd, T item, ICollection<string> updateFields = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
<T> | item |
ICollection<System.String> | updateFields |
Type Parameters
T
ToInsertStatement<T>(IDbCommand, T, ICollection<String>)
View Source
Declaration
string ToInsertStatement<T>(IDbCommand dbCmd, T item, ICollection<string> insertFields = null)
Returns
System.String
Parameters
| Type | Name |
|---|---|
IDbCommand | dbCmd |
<T> | item |
ICollection<System.String> | insertFields |
Type Parameters
T
MergeParamsIntoSql(String, IEnumerable<IDbDataParameter>)
View Source
Declaration
string MergeParamsIntoSql(string sql, IEnumerable<IDbDataParameter> dbParams)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | sql |
IEnumerable<IDbDataParameter> | dbParams |
GetRefSelfSql<From>(SqlExpression<From>, ModelDefinition, FieldDefinition, ModelDefinition)
View Source
Declaration
string GetRefSelfSql<From>(SqlExpression<From> refQ, ModelDefinition modelDef, FieldDefinition refSelf, ModelDefinition refModelDef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
| ServiceStack.OrmLite.SqlExpression<T> | refQ |
| ServiceStack.OrmLite.ModelDefinition | modelDef |
| ServiceStack.OrmLite.FieldDefinition | refSelf |
| ServiceStack.OrmLite.ModelDefinition | refModelDef |
Type Parameters
From
GetRefFieldSql(String, ModelDefinition, FieldDefinition)
View Source
Declaration
string GetRefFieldSql(string subSql, ModelDefinition refModelDef, FieldDefinition refField)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | subSql |
| ServiceStack.OrmLite.ModelDefinition | refModelDef |
| ServiceStack.OrmLite.FieldDefinition | refField |
GetFieldReferenceSql(String, FieldDefinition, FieldReference)
View Source
Declaration
string GetFieldReferenceSql(string subSql, FieldDefinition fieldDef, FieldReference fieldRef)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | subSql |
| ServiceStack.OrmLite.FieldDefinition | fieldDef |
| ServiceStack.OrmLite.FieldReference | fieldRef |
ToTableNamesStatement(String)
View Source
Declaration
string ToTableNamesStatement(string schema)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | schema |
ToTableNamesWithRowCountsStatement(Boolean, String)
Return table, row count SQL for listing all tables with their row counts
View Source
Declaration
string ToTableNamesWithRowCountsStatement(bool live, string schema)
Returns
System.String
Parameters
| Type | Name | Description |
|---|---|---|
System.Boolean | live | If true returns live current row counts of each table (slower), otherwise returns cached row counts from RDBMS table stats |
|
| System.String | schema | The table schema if any
|
SqlConflict(String, String)
View Source
Declaration
string SqlConflict(string sql, string conflictResolution)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | sql |
System.String | conflictResolution |
SqlConcat(IEnumerable<Object>)
View Source
Declaration
string SqlConcat(IEnumerable<object> args)
Returns
System.String
Parameters
| Type | Name |
|---|---|
IEnumerable<System.Object> | args |
SqlCurrency(String)
View Source
Declaration
string SqlCurrency(string fieldOrValue)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | fieldOrValue |
SqlCurrency(String, String)
View Source
Declaration
string SqlCurrency(string fieldOrValue, string currencySymbol)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.String | fieldOrValue |
System.String | currencySymbol |
SqlBool(Boolean)
View Source
Declaration
string SqlBool(bool value)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Boolean | value |
SqlLimit(Nullable<Int32>, Nullable<Int32>)
View Source
Declaration
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
string SqlCast(object fieldOrValue, string castAs)
Returns
System.String
Parameters
| Type | Name |
|---|---|
System.Object | fieldOrValue |
System.String | castAs |
GenerateComment(in String)
Generates a SQL comment.
View Source
Declaration
string GenerateComment(in string text)
Returns
System.String: The generated SQL.
Parameters
| Type | Name | Description |
|---|---|---|
System.String | text | The comment text. |
|