ServiceStack.OrmLite.MySql by Demis Bellot, Thomas Grassauer

<PackageReference Include="ServiceStack.OrmLite.MySql" Version="3.9.57" />

---

API Diff between 3.9.57 and 4.0.9

740 Additions 1 Removals

ServiceStack.DataAnnotations

• public class BelongToAttribute : Attribute
  • public Type BelongToTableType { get; set; }
  • public BelongToAttribute(Type belongToTableType)
• public class ComputeAttribute : Attribute
  • public string Expression { get; set; }
  • public ComputeAttribute()
  • public ComputeAttribute(string expression)
• public class DecimalLengthAttribute : Attribute
  • public int Precision { get; set; }
  • public int Scale { get; set; }
  • public DecimalLengthAttribute(int precision, int scale)
  • public DecimalLengthAttribute(int precision)
  • public DecimalLengthAttribute()
• public class IgnoreAttribute : Attribute
  • public IgnoreAttribute()
• public class PrimaryKeyAttribute : Attribute
  • public PrimaryKeyAttribute()
• public class SequenceAttribute : Attribute
  • public string Name { get; set; }
  • public SequenceAttribute(string name)

ServiceStack.OrmLite

• public sealed delegate ConvertDbValueDelegate : MulticastDelegate
  • public ConvertDbValueDelegate(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object value, Type type, AsyncCallback callback, object object)
  • public virtual object EndInvoke(IAsyncResult result)
  • public virtual object Invoke(object value, Type type)
• public class DbTypes<TDialect> where TDialect : IOrmLiteDialectProvider
  • public Dictionary<Type, DbType> ColumnDbTypeMap
  • public Dictionary<Type, string> ColumnTypeMap
  • public DbType DbType
  • public bool ShouldQuoteValue
  • public string TextDefinition
  • public DbTypes()
  • public void Set<T>(DbType dbType, string fieldDefinition)
• public class EnumMemberAccess : PartialSqlString
  • public Type EnumType { get; }
  • public EnumMemberAccess(string text, Type enumType)
• public abstract class ExpressionVisitor
  • protected ExpressionVisitor()
  • protected virtual Expression Visit(Expression exp)
  • protected virtual Expression VisitBinary(BinaryExpression b)
  • protected virtual MemberBinding VisitBinding(MemberBinding binding)
  • protected virtual IEnumerable<MemberBinding> VisitBindingList(ReadOnlyCollection<MemberBinding> original)
  • protected virtual Expression VisitConditional(ConditionalExpression c)
  • protected virtual Expression VisitConstant(ConstantExpression c)
  • protected virtual ElementInit VisitElementInitializer(ElementInit initializer)
  • protected virtual IEnumerable<ElementInit> VisitElementInitializerList(ReadOnlyCollection<ElementInit> original)
  • protected virtual ReadOnlyCollection<Expression> VisitExpressionList(ReadOnlyCollection<Expression> original)
  • protected virtual Expression VisitInvocation(InvocationExpression iv)
  • protected virtual Expression VisitLambda(LambdaExpression lambda)
  • protected virtual Expression VisitListInit(ListInitExpression init)
  • protected virtual Expression VisitMemberAccess(MemberExpression m)
  • protected virtual MemberAssignment VisitMemberAssignment(MemberAssignment assignment)
  • protected virtual Expression VisitMemberInit(MemberInitExpression init)
  • protected virtual MemberListBinding VisitMemberListBinding(MemberListBinding binding)
  • protected virtual MemberMemberBinding VisitMemberMemberBinding(MemberMemberBinding binding)
  • protected virtual Expression VisitMethodCall(MethodCallExpression m)
  • protected virtual NewExpression VisitNew(NewExpression nex)
  • protected virtual Expression VisitNewArray(NewArrayExpression na)
  • protected virtual Expression VisitParameter(ParameterExpression p)
  • protected virtual Expression VisitTypeIs(TypeBinaryExpression b)
  • protected virtual Expression VisitUnary(UnaryExpression u)
• public class FieldDefinition
  • public string Alias { get; set; }
  • public bool AutoIncrement { get; set; }
  • public string BelongToModelName { get; set; }
  • public string ComputeExpression { get; set; }
  • public string DefaultValue { get; set; }
  • public int? FieldLength { get; set; }
  • public string FieldName { get; }
  • public Type FieldType { get; set; }
  • public ForeignKeyConstraint ForeignKey { get; set; }
  • public PropertyGetterDelegate GetValueFn { get; set; }
  • public bool IsComputed { get; set; }
  • public bool IsIndexed { get; set; }
  • public bool IsNullable { get; set; }
  • public bool IsPrimaryKey { get; set; }
  • public bool IsUnique { get; set; }
  • public string Name { get; set; }
  • public PropertyInfo PropertyInfo { get; set; }
  • public int? Scale { get; set; }
  • public string Sequence { get; set; }
  • public PropertySetterDelegate SetValueFn { get; set; }
  • public FieldDefinition()
  • public string GetQuotedValue(object fromInstance)
  • public object GetValue(object onInstance)
  • public void SetValue(object onInstance, object withValue)
• public class ForeignKeyAttribute : ReferencesAttribute
  • public string ForeignKeyName { get; set; }
  • public string OnDelete { get; set; }
  • public string OnUpdate { get; set; }
  • public ForeignKeyAttribute(Type type)
• public class ForeignKeyConstraint
  • public string ForeignKeyName { get; }
  • public string OnDelete { get; }
  • public string OnUpdate { get; }
  • public Type ReferenceType { get; }
  • public ForeignKeyConstraint(Type type, string onDelete = null, string onUpdate = null, string foreignKeyName = null)
  • public string GetForeignKeyName(ModelDefinition modelDef, ModelDefinition refModelDef, INamingStrategy NamingStrategy, FieldDefinition fieldDef)
• public sealed delegate GetQuotedValueDelegate : MulticastDelegate
  • public GetQuotedValueDelegate(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object value, Type fieldType, AsyncCallback callback, object object)
  • public virtual string EndInvoke(IAsyncResult result)
  • public virtual string Invoke(object value, Type fieldType)
• public sealed delegate GetValueDelegate : MulticastDelegate
  • public GetValueDelegate(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(int i, AsyncCallback callback, object object)
  • public virtual object EndInvoke(IAsyncResult result)
  • public virtual object Invoke(int i)
• public interface INamingStrategy
  • string GetColumnName(string name)
  • string GetTableName(string name)
• public interface IOrmLiteDialectProvider
  • int DefaultStringLength { get; set; }
  • INamingStrategy NamingStrategy { get; set; }
  • string ParamString { get; set; }
  • bool UseUnicode { get; set; }
  • object ConvertDbValue(object value, Type type)
  • IDbConnection CreateConnection(string filePath, Dictionary<string, string> options)
  • IDbCommand CreateParameterizedDeleteStatement(object objWithProperties, IDbConnection connection)
  • IDbCommand CreateParameterizedInsertStatement(object objWithProperties, IDbConnection connection)
  • IDbCommand CreateParameterizedInsertStatement(object objWithProperties, IList<string> insertFields, IDbConnection connection)
  • IDbCommand CreateParameterizedUpdateStatement(object objWithProperties, IDbConnection connection)
  • IDbCommand CreateParameterizedUpdateStatement(object objWithProperties, IList<string> updateFields, IDbConnection connection)
  • bool DoesSequenceExist(IDbCommand dbCmd, string sequencName)
  • bool DoesTableExist(IDbConnection db, string tableName)
  • bool DoesTableExist(IDbCommand dbCmd, string tableName)
  • SqlExpressionVisitor<T> ExpressionVisitor<T>()
  • DbType GetColumnDbType(Type valueType)
  • string GetColumnDefinition(string fieldName, Type fieldType, bool isPrimaryKey, bool autoIncrement, bool isNullable, int? fieldLength, int? scale, string defaultValue)
  • string GetColumnNames(ModelDefinition modelDef)
  • string GetColumnTypeDefinition(Type fieldType)
  • string GetDropForeignKeyConstraints(ModelDefinition modelDef)
  • long GetLastInsertId(IDbCommand command)
  • string GetQuotedColumnName(string columnName)
  • string GetQuotedName(string columnName)
  • string GetQuotedParam(string paramValue)
  • string GetQuotedTableName(ModelDefinition modelDef)
  • string GetQuotedTableName(string tableName)
  • string GetQuotedValue(object value, Type fieldType)
  • void ReParameterizeInsertStatement(object objWithProperties, IDbCommand command)
  • void ReParameterizeInsertStatement(object objWithProperties, IList<string> insertFields, IDbCommand command)
  • List<string> SequenceList(Type tableType)
  • string ToAddColumnStatement(Type modelType, FieldDefinition fieldDef)
  • string ToAddForeignKeyStatement<T, TForeign>(Expression<Func<T, object>> field, Expression<Func<TForeign, object>> foreignField, OnFkOption onUpdate, OnFkOption onDelete, string foreignKeyName = null)
  • string ToAlterColumnStatement(Type modelType, FieldDefinition fieldDef)
  • string ToChangeColumnNameStatement(Type modelType, FieldDefinition fieldDef, string oldColumnName)
  • string ToCountStatement(Type fromTableType, string sqlFilter, object[] filterParams)
  • string ToCreateIndexStatement<T>(Expression<Func<T, object>> field, string indexName = null, bool unique = false)
  • List<string> ToCreateIndexStatements(Type tableType)
  • string ToCreateSequenceStatement(Type tableType, string sequenceName)
  • List<string> ToCreateSequenceStatements(Type tableType)
  • string ToCreateTableStatement(Type tableType)
  • string ToDeleteRowStatement(object objWithProperties)
  • string ToDeleteStatement(Type tableType, string sqlFilter, object[] filterParams)
  • string ToExecuteProcedureStatement(object objWithProperties)
  • string ToExistStatement(Type fromTableType, object objWithProperties, string sqlFilter, object[] filterParams)
  • string ToInsertRowStatement(object objWithProperties, IDbCommand command)
  • string ToInsertRowStatement(object objWithProperties, IList<string> InsertFields, IDbCommand command)
  • string ToSelectFromProcedureStatement(object fromObjWithProperties, Type outputModelType, string sqlFilter, object[] filterParams)
  • string ToSelectStatement(Type tableType, string sqlFilter, object[] filterParams)
  • string ToUpdateRowStatement(object objWithProperties)
  • string ToUpdateRowStatement(object objWithProperties, IList<string> UpdateFields)
• public interface IPropertyInvoker
  • Func<object, Type, object> ConvertValueFn { get; set; }
  • object GetPropertyValue(PropertyInfo propertyInfo, object fromInstance)
  • void SetPropertyValue(PropertyInfo propertyInfo, Type fieldType, object onInstance, object withValue)
• public class JoinSqlBuilder<TNewPoco, TBasePoco>
  • public JoinSqlBuilder()
  • public JoinSqlBuilder<TNewPoco, TBasePoco> And<T>(Expression<Func<T, bool>> where)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> Clear()
  • public JoinSqlBuilder<TNewPoco, TBasePoco> CrossJoin<TSourceTable, TDestinationTable>(Expression<Func<TSourceTable, object>> sourceTableColumnSelection = null, Expression<Func<TDestinationTable, object>> destinationTableColumnSelection = null, Expression<Func<TSourceTable, bool>> sourceWhere = null, Expression<Func<TDestinationTable, bool>> destinationWhere = null)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> FullJoin<TSourceTable, TDestinationTable>(Expression<Func<TSourceTable, object>> sourceColumn, Expression<Func<TDestinationTable, object>> destinationColumn, Expression<Func<TSourceTable, object>> sourceTableColumnSelection = null, Expression<Func<TDestinationTable, object>> destinationTableColumnSelection = null, Expression<Func<TSourceTable, bool>> sourceWhere = null, Expression<Func<TDestinationTable, bool>> destinationWhere = null)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> Join<TSourceTable, TDestinationTable>(Expression<Func<TSourceTable, object>> sourceColumn, Expression<Func<TDestinationTable, object>> destinationColumn, Expression<Func<TSourceTable, object>> sourceTableColumnSelection = null, Expression<Func<TDestinationTable, object>> destinationTableColumnSelection = null, Expression<Func<TSourceTable, bool>> sourceWhere = null, Expression<Func<TDestinationTable, bool>> destinationWhere = null)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> LeftJoin<TSourceTable, TDestinationTable>(Expression<Func<TSourceTable, object>> sourceColumn, Expression<Func<TDestinationTable, object>> destinationColumn, Expression<Func<TSourceTable, object>> sourceTableColumnSelection = null, Expression<Func<TDestinationTable, object>> destinationTableColumnSelection = null, Expression<Func<TSourceTable, bool>> sourceWhere = null, Expression<Func<TDestinationTable, bool>> destinationWhere = null)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> Or<T>(Expression<Func<T, bool>> where)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> OrderBy<T>(Expression<Func<T, object>> sourceColumn)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> OrderByDescending<T>(Expression<Func<T, object>> sourceColumn)
  • protected void ProcessMemberAccess(string tableName, MemberExpression m, List<string> lst, bool withTablePrefix, string alias = "")
  • public JoinSqlBuilder<TNewPoco, TBasePoco> RightJoin<TSourceTable, TDestinationTable>(Expression<Func<TSourceTable, object>> sourceColumn, Expression<Func<TDestinationTable, object>> destinationColumn, Expression<Func<TSourceTable, object>> sourceTableColumnSelection = null, Expression<Func<TDestinationTable, object>> destinationTableColumnSelection = null, Expression<Func<TSourceTable, bool>> sourceWhere = null, Expression<Func<TDestinationTable, bool>> destinationWhere = null)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> Select<T>(Expression<Func<T, object>> selectColumns)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectAll<T>()
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectAverage<T>(Expression<Func<T, object>> selectColumn)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectCount<T>(Expression<Func<T, object>> selectColumn)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectDistinct()
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectMax<T>(Expression<Func<T, object>> selectColumn)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectMin<T>(Expression<Func<T, object>> selectColumn)
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectMin()
  • public JoinSqlBuilder<TNewPoco, TBasePoco> SelectSum<T>(Expression<Func<T, object>> selectColumn)
  • public string ToSql()
  • public JoinSqlBuilder<TNewPoco, TBasePoco> Where<T>(Expression<Func<T, bool>> where)
• public class ModelDefinition
  • public string Alias { get; set; }
  • public FieldDefinition[] AllFieldDefinitionsArray { get; }
  • public List<CompositeIndexAttribute> CompositeIndexes { get; set; }
  • public List<FieldDefinition> FieldDefinitions { get; set; }
  • public FieldDefinition[] FieldDefinitionsArray { get; }
  • public List<FieldDefinition> IgnoredFieldDefinitions { get; set; }
  • public FieldDefinition[] IgnoredFieldDefinitionsArray { get; }
  • public bool IsInSchema { get; }
  • public string ModelName { get; }
  • public Type ModelType { get; set; }
  • public string Name { get; set; }
  • public FieldDefinition PrimaryKey { get; }
  • public string Schema { get; set; }
  • public string SqlSelectAllFromTable { get; set; }
  • public ModelDefinition()
  • public FieldDefinition GetFieldDefinition<T>(Expression<Func<T, object>> field)
• public static class ModelDefinition<T>
  • public static ModelDefinition Definition { get; }
  • public static string PrimaryKeyName { get; }
• public enum OnFkOption
  • Cascade = 0
  • NoAction = 2
  • Restrict = 4
  • SetDefault = 3
  • SetNull = 1
• public static class OrmLiteConfig
  • public const string IdField = "Id"
  • public static IOrmLiteDialectProvider TSDialectProvider
  • public static IDbTransaction TSTransaction
  • public static IOrmLiteDialectProvider DialectProvider { get; set; }
  • public static void ClearCache()
  • public static IDbConnection OpenDbConnection(this string dbConnectionStringOrFilePath)
  • public static IDbConnection OpenReadOnlyDbConnection(this string dbConnectionStringOrFilePath)
  • public static IDbConnection ToDbConnection(this string dbConnectionStringOrFilePath)
  • public static IDbConnection ToDbConnection(this string dbConnectionStringOrFilePath, IOrmLiteDialectProvider dialectProvider)
• public class OrmLiteConnection : IDbConnection, IDisposable, IHasDbConnection
  • public readonly OrmLiteConnectionFactory Factory
  • public string ConnectionString { get; set; }
  • public int ConnectionTimeout { get; }
  • public string Database { get; }
  • public IDbConnection DbConnection { get; }
  • public ConnectionState State { get; }
  • public IDbTransaction Transaction { get; }
  • public OrmLiteConnection(OrmLiteConnectionFactory factory)
  • public static SqlConnection op_Explicit(OrmLiteConnection dbConn)
  • public static DbConnection op_Explicit(OrmLiteConnection dbConn)
  • public IDbTransaction BeginTransaction()
  • public IDbTransaction BeginTransaction(IsolationLevel isolationLevel)
  • public void ChangeDatabase(string databaseName)
  • public void Close()
  • public IDbCommand CreateCommand()
  • public void Dispose()
  • public void Open()
• public class OrmLiteConnectionFactory : IDbConnectionFactory
  • public static Dictionary<string, OrmLiteConnectionFactory> NamedConnections { get; }
  • public IDbCommand AlwaysReturnCommand { get; set; }
  • public IDbTransaction AlwaysReturnTransaction { get; set; }
  • public bool AutoDisposeConnection { get; set; }
  • public Func<IDbConnection, IDbConnection> ConnectionFilter { get; set; }
  • public string ConnectionString { get; set; }
  • public IOrmLiteDialectProvider DialectProvider { get; set; }
  • public Action<OrmLiteConnection> OnDispose { get; set; }
  • public OrmLiteConnectionFactory()
  • public OrmLiteConnectionFactory(string connectionString)
  • public OrmLiteConnectionFactory(string connectionString, bool autoDisposeConnection)
  • public OrmLiteConnectionFactory(string connectionString, IOrmLiteDialectProvider dialectProvider)
  • public OrmLiteConnectionFactory(string connectionString, bool autoDisposeConnection, IOrmLiteDialectProvider dialectProvider)
  • public OrmLiteConnectionFactory(string connectionString, bool autoDisposeConnection, IOrmLiteDialectProvider dialectProvider, bool setGlobalConnection)
  • public IDbConnection CreateDbConnection()
  • public IDbConnection OpenDbConnection()
  • public IDbConnection OpenDbConnection(string connectionKey)
  • public void RegisterConnection(string connectionKey, string connectionString, IOrmLiteDialectProvider dialectProvider, bool autoDisposeConnection = true)
  • public void RegisterConnection(string connectionKey, OrmLiteConnectionFactory connectionFactory)
• public static class OrmLiteConnectionFactoryExtensions
  • public static void Exec(this IDbConnectionFactory connectionFactory, Action<IDbCommand> runDbCommandsFn)
  • public static T Exec<T>(this IDbConnectionFactory connectionFactory, Func<IDbCommand, T> runDbCommandsFn)
  • public static IDbConnection Open(this IDbConnectionFactory connectionFactory)
  • public static IDbConnection Open(this IDbConnectionFactory connectionFactory, string namedConnection)
  • public static IDbConnection OpenDbConnection(this IDbConnectionFactory connectionFactory, string namedConnection)
  • public static void Run(this IDbConnectionFactory connectionFactory, Action<IDbConnection> runDbCommandsFn)
  • public static T Run<T>(this IDbConnectionFactory connectionFactory, Func<IDbConnection, T> runDbCommandsFn)
• public static class OrmLiteDDLExtensions
  • public static void AddColumn<T>(this IDbConnection dbConn, Expression<Func<T, object>> field)
  • public static void AddColumn(this IDbConnection dbConn, Type modelType, FieldDefinition fieldDef)
  • public static void AddForeignKey<T, TForeign>(this IDbConnection dbConn, Expression<Func<T, object>> field, Expression<Func<TForeign, object>> foreignField, OnFkOption onUpdate, OnFkOption onDelete, string foreignKeyName = null)
  • public static void AlterColumn<T>(this IDbConnection dbConn, Expression<Func<T, object>> field)
  • public static void AlterColumn(this IDbConnection dbConn, Type modelType, FieldDefinition fieldDef)
  • public static void AlterTable<T>(this IDbConnection dbConn, string command)
  • public static void AlterTable(this IDbConnection dbConn, Type modelType, string command)
  • public static void ChangeColumnName<T>(this IDbConnection dbConn, Expression<Func<T, object>> field, string oldColumnName)
  • public static void ChangeColumnName(this IDbConnection dbConn, Type modelType, FieldDefinition fieldDef, string oldColumnName)
  • public static void CreateIndex<T>(this IDbConnection dbConn, Expression<Func<T, object>> field, string indexName = null, bool unique = false)
  • public static void DropColumn<T>(this IDbConnection dbConn, string columnName)
  • public static void DropColumn(this IDbConnection dbConn, Type modelType, string columnName)
  • public static void DropForeignKey<T>(this IDbConnection dbConn, string foreignKeyName)
  • public static void DropIndex<T>(this IDbConnection dbConn, string indexName)
• public abstract class OrmLiteDialectProviderBase<TDialect> : IOrmLiteDialectProvider where TDialect : IOrmLiteDialectProvider
  • protected static readonly ILog Log
  • public string AutoIncrementDefinition
  • public string BlobColumnDefinition
  • public string BoolColumnDefinition
  • public string DateTimeColumnDefinition
  • protected DbTypes<TDialect> DbTypeMap
  • public string DecimalColumnDefinition
  • public string DefaultValueFormat
  • public string GuidColumnDefinition
  • public string IntColumnDefinition
  • public string LongColumnDefinition
  • public string RealColumnDefinition
  • public string StringColumnDefinition
  • public string StringLengthColumnDefinitionFormat
  • public string StringLengthNonUnicodeColumnDefinitionFormat
  • public string StringLengthUnicodeColumnDefinitionFormat
  • public string TimeColumnDefinition
  • protected bool useUnicode
  • public int DefaultDecimalPrecision { get; set; }
  • public int DefaultDecimalScale { get; set; }
  • public int DefaultStringLength { get; set; }
  • public INamingStrategy NamingStrategy { get; set; }
  • public string ParamString { get; set; }
  • public virtual bool UseUnicode { get; set; }
  • protected OrmLiteDialectProviderBase()
  • protected static ModelDefinition GetModel(Type modelType)
  • public static ModelDefinition GetModelDefinition(Type modelType)
  • protected virtual void AddParameterForFieldToCommand(IDbCommand command, FieldDefinition fieldDef, object objWithProperties)
  • public virtual object ConvertDbValue(object value, Type type)
  • public abstract IDbConnection CreateConnection(string filePath, Dictionary<string, string> options)
  • public IDbCommand CreateParameterizedDeleteStatement(object objWithProperties, IDbConnection connection)
  • public virtual IDbCommand CreateParameterizedInsertStatement(object objWithProperties, IDbConnection connection)
  • public virtual IDbCommand CreateParameterizedInsertStatement(object objWithProperties, IList<string> insertFields, IDbConnection connection)
  • public virtual IDbCommand CreateParameterizedUpdateStatement(object objWithProperties, IDbConnection connection)
  • public virtual IDbCommand CreateParameterizedUpdateStatement(object objWithProperties, IList<string> updateFields, IDbConnection connection)
  • public virtual bool DoesSequenceExist(IDbCommand dbCmd, string sequenceName)
  • public virtual bool DoesTableExist(IDbConnection db, string tableName)
  • public virtual bool DoesTableExist(IDbCommand dbCmd, string tableName)
  • public virtual SqlExpressionVisitor<T> ExpressionVisitor<T>()
  • protected virtual string FkOptionToString(OnFkOption option)
  • public virtual DbType GetColumnDbType(Type valueType)
  • public virtual string GetColumnDefinition(string fieldName, Type fieldType, bool isPrimaryKey, bool autoIncrement, bool isNullable, int? fieldLength, int? scale, string defaultValue)
  • public virtual string GetColumnNames(ModelDefinition modelDef)
  • public virtual string GetColumnTypeDefinition(Type fieldType)
  • protected virtual string GetCompositeIndexName(CompositeIndexAttribute compositeIndex, ModelDefinition modelDef)
  • protected virtual string GetCompositeIndexNameWithSchema(CompositeIndexAttribute compositeIndex, ModelDefinition modelDef)
  • public virtual string GetDropForeignKeyConstraints(ModelDefinition modelDef)
  • public virtual string GetForeignKeyOnDeleteClause(ForeignKeyConstraint foreignKey)
  • public virtual string GetForeignKeyOnUpdateClause(ForeignKeyConstraint foreignKey)
  • protected virtual string GetIndexName(bool isUnique, string modelName, string fieldName)
  • public abstract long GetLastInsertId(IDbCommand command)
  • public virtual string GetQuotedColumnName(string columnName)
  • public virtual string GetQuotedName(string name)
  • public virtual string GetQuotedParam(string paramValue)
  • public virtual string GetQuotedTableName(ModelDefinition modelDef)
  • public virtual string GetQuotedTableName(string tableName)
  • public virtual string GetQuotedValue(object value, Type fieldType)
  • protected virtual string GetUndefinedColumnDefinition(Type fieldType, int? fieldLength)
  • protected object GetValueOrDbNull(FieldDefinition fieldDef, object objWithProperties)
  • protected void InitColumnTypeMap()
  • public void ReParameterizeInsertStatement(object objWithProperties, IDbCommand command)
  • public void ReParameterizeInsertStatement(object objWithProperties, IList<string> insertFields, IDbCommand command)
  • public virtual List<string> SequenceList(Type tableType)
  • public virtual bool ShouldQuoteValue(Type fieldType)
  • public virtual string ToAddColumnStatement(Type modelType, FieldDefinition fieldDef)
  • public virtual string ToAddForeignKeyStatement<T, TForeign>(Expression<Func<T, object>> field, Expression<Func<TForeign, object>> foreignField, OnFkOption onUpdate, OnFkOption onDelete, string foreignKeyName = null)
  • public virtual string ToAlterColumnStatement(Type modelType, FieldDefinition fieldDef)
  • public virtual string ToChangeColumnNameStatement(Type modelType, FieldDefinition fieldDef, string oldColumnName)
  • public virtual string ToCountStatement(Type fromTableType, string sqlFilter, object[] filterParams)
  • protected virtual string ToCreateIndexStatement(bool isUnique, string indexName, ModelDefinition modelDef, string fieldName, bool isCombined = false)
  • public virtual string ToCreateIndexStatement<T>(Expression<Func<T, object>> field, string indexName = null, bool unique = false)
  • public virtual List<string> ToCreateIndexStatements(Type tableType)
  • public virtual string ToCreateSequenceStatement(Type tableType, string sequenceName)
  • public virtual List<string> ToCreateSequenceStatements(Type tableType)
  • public virtual string ToCreateTableStatement(Type tableType)
  • public virtual string ToDeleteRowStatement(object objWithProperties)
  • public virtual string ToDeleteStatement(Type tableType, string sqlFilter, object[] filterParams)
  • public virtual string ToExecuteProcedureStatement(object objWithProperties)
  • public virtual string ToExistStatement(Type fromTableType, object objWithProperties, string sqlFilter, object[] filterParams)
  • public virtual string ToInsertRowStatement(object objWithProperties, IDbCommand command)
  • public virtual string ToInsertRowStatement(object objWithProperties, IList<string> insertFields, IDbCommand command)
  • public virtual string ToSelectFromProcedureStatement(object fromObjWithProperties, Type outputModelType, string sqlFilter, object[] filterParams)
  • public virtual string ToSelectStatement(Type tableType, string sqlFilter, object[] filterParams)
  • public virtual string ToUpdateRowStatement(object objWithProperties)
  • public virtual string ToUpdateRowStatement(object objWithProperties, IList<string> updateFields)
• public class OrmLiteNamingStrategyBase : INamingStrategy
  • public OrmLiteNamingStrategyBase()
  • public virtual string GetColumnName(string name)
  • public virtual string GetTableName(string name)
• public class OrmLitePersistenceProvider : IBasicPersistenceProvider, IDisposable
  • protected IDbConnection connection
  • protected bool DisposeConnection
  • public IDbConnection Connection { get; }
  • protected string ConnectionString { get; protected set; }
  • public OrmLitePersistenceProvider(string connectionString)
  • public OrmLitePersistenceProvider(IDbConnection connection)
  • public void Delete<T>(T entity)
  • public void DeleteAll<TEntity>()
  • public void DeleteById<T>(object id)
  • public void DeleteByIds<T>(ICollection ids)
  • public void Dispose()
  • public T GetById<T>(object id)
  • public IList<T> GetByIds<T>(ICollection ids)
  • public T Store<T>(T entity)
  • public void StoreAll<TEntity>(IEnumerable<TEntity> entities)
• public static class OrmLiteReadConnectionExtensions
  • public static List<T> ByExampleWhere<T>(this IDbConnection dbConn, object anonType)
  • public static Dictionary<K, V> Dictionary<K, V>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static IEnumerable<T> Each<T>(this IDbConnection dbConn)
  • public static IEnumerable<T> Each<T>(this IDbConnection dbConn, string filter, object[] filterParams)
  • public static IEnumerable<T> EachWhere<T>(this IDbConnection dbConn, object anonType)
  • public static bool Exists<T>(this IDbConnection dbConn, string sqlFilter, object[] filterParams)
  • public static bool Exists<T>(this IDbConnection dbConn, object record)
  • public static T First<T>(this IDbConnection dbConn, string filter, object[] filterParams)
  • public static T First<T>(this IDbConnection dbConn, string filter)
  • public static T FirstOrDefault<T>(this IDbConnection dbConn, string filter, object[] filterParams)
  • public static T FirstOrDefault<T>(this IDbConnection dbConn, string filter)
  • public static T GetById<T>(this IDbConnection dbConn, object idValue)
  • public static T GetByIdOrDefault<T>(this IDbConnection dbConn, object idValue)
  • public static T GetByIdParam<T>(this IDbConnection dbConn, object idValue)
  • public static List<T> GetByIds<T>(this IDbConnection dbConn, IEnumerable idValues)
  • public static Dictionary<K, V> GetDictionary<K, V>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static List<T> GetFirstColumn<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static HashSet<T> GetFirstColumnDistinct<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static HashSet<T> GetHashSet<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static long GetLastInsertId(this IDbConnection dbConn)
  • public static List<T> GetList<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static long GetLongScalar(this IDbConnection dbConn)
  • public static Dictionary<K, List<V>> GetLookup<K, V>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static T GetScalar<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static bool HasChildren<T>(this IDbConnection dbConn, object record)
  • public static HashSet<T> HashSet<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static T Id<T>(this IDbConnection dbConn, object idValue)
  • public static T IdOrDefault<T>(this IDbConnection dbConn, object idValue)
  • public static List<T> Ids<T>(this IDbConnection dbConn, IEnumerable idValues)
  • public static List<T> List<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static Dictionary<K, List<V>> Lookup<K, V>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static List<T> Query<T>(this IDbConnection dbConn, string sql)
  • public static List<T> Query<T>(this IDbConnection dbConn, string sql, object anonType)
  • public static List<T> Query<T>(this IDbConnection dbConn, string sql, Dictionary<string, object> dict)
  • public static List<T> QueryByExample<T>(this IDbConnection dbConn, string sql, object anonType = null)
  • public static T QueryById<T>(this IDbConnection dbConn, object value)
  • public static IEnumerable<T> QueryEach<T>(this IDbConnection dbConn, string sql, object anonType = null)
  • public static T QueryScalar<T>(this IDbConnection dbConn, object anonType)
  • public static T QueryScalar<T>(this IDbConnection dbConn, string sql, object anonType = null)
  • public static T QuerySingle<T>(this IDbConnection dbConn, object anonType)
  • public static T QuerySingle<T>(this IDbConnection dbConn, string sql, object anonType = null)
  • public static T Scalar<T>(this IDbConnection dbConn, string sql, object[] sqlParams)
  • public static List<T> Select<T>(this IDbConnection dbConn)
  • public static List<T> Select<T>(this IDbConnection dbConn, string sqlFilter, object[] filterParams)
  • public static List<TModel> Select<TModel>(this IDbConnection dbConn, Type fromTableType)
  • public static List<TModel> Select<TModel>(this IDbConnection dbConn, Type fromTableType, string sqlFilter, object[] filterParams)
  • public static List<TOutputModel> SelectFromProcedure<TOutputModel>(this IDbConnection dbConn, object fromObjWithProperties)
  • public static List<TOutputModel> SelectFromProcedure<TOutputModel>(this IDbConnection dbConn, object fromObjWithProperties, string sqlFilter, object[] filterParams)
  • public static T Single<T>(this IDbConnection dbConn, string filter, object[] filterParams)
  • public static T Single<T>(this IDbConnection dbConn, string filter)
  • public static T SingleOrDefault<T>(this IDbConnection dbConn, string filter, object[] filterParams)
  • public static T SingleOrDefault<T>(this IDbConnection dbConn, string filter)
  • public static T SingleWhere<T>(this IDbConnection dbConn, string name, object value)
  • public static List<T> SqlList<T>(this IDbConnection dbConn, string sql)
  • public static List<T> SqlList<T>(this IDbConnection dbConn, string sql, object anonType)
  • public static List<T> SqlList<T>(this IDbConnection dbConn, string sql, Dictionary<string, object> dict)
  • public static T SqlScalar<T>(this IDbConnection dbConn, string sql, object anonType = null)
  • public static T SqlScalar<T>(this IDbConnection dbConn, string sql, Dictionary<string, object> dict)
  • public static List<T> Where<T>(this IDbConnection dbConn, string name, object value)
  • public static List<T> Where<T>(this IDbConnection dbConn, object anonType)
  • public static List<T> Where<T>(this IDbConnection dbConn, Expression<Func<T, bool>> Predicate)
• public static class OrmLiteReadExtensions
  • public const string UseDbConnectionExtensions = "Use IDbConnection Extensions instead"
  • public static void ClearFilters(this IDbCommand dbCmd)
  • public static HashSet<T> GetHashSet<T>(this IDbCommand dbCmd, string sql, object[] sqlParams)
  • public static long GetLongScalar(this IDbCommand dbCmd)
  • public static GetValueDelegate GetValueFn<T>(IDataRecord reader)
  • public static bool IsScalar<T>()
  • public static void SetFilters<T>(this IDbCommand dbCmd, object anonType, bool excludeNulls)
  • public static void SetFilters<T>(this IDbCommand dbCmd, object anonType)
• public class OrmLiteSPStatement
  • public OrmLiteSPStatement(IDbCommand cmd)
  • public List<T> ConvertFirstColumnToList<T>()
  • public HashSet<T> ConvertFirstColumnToListDistinct<T>()
  • public T ConvertTo<T>()
  • public List<T> ConvertToList<T>()
  • public T ConvertToScalar<T>()
  • public List<T> ConvertToScalarList<T>()
  • public int ExecuteNonQuery()
  • public bool HasResult()
• public class OrmLiteTransaction : IDbTransaction, IDisposable
  • public IDbConnection Connection { get; }
  • public IsolationLevel IsolationLevel { get; }
  • public OrmLiteTransaction(IDbConnection db, IDbTransaction trans)
  • public void Commit()
  • public void Dispose()
  • public void Rollback()
• public static class OrmLiteUtilExtensions
  • public static T ConvertTo<T>(this IDataReader dataReader)
  • public static List<T> ConvertToList<T>(this IDataReader dataReader)
  • public static T CreateInstance<T>()
  • public static string GetColumnNames(this ModelDefinition modelDef)
  • public static string Params(this string sqlText, object[] sqlParams)
  • public static string SqlFormat(this string sqlText, object[] sqlParams)
  • public static SqlInValues SqlInValues<T>(this List<T> values)
  • public static SqlInValues SqlInValues<T>(this T[] values)
  • public static string SqlJoin<T>(this List<T> values)
  • public static string SqlJoin(IEnumerable values)
• public static class OrmLiteWriteConnectionExtensions
  • public static IDbTransaction BeginTransaction(this IDbConnection dbConn)
  • public static IDbTransaction BeginTransaction(this IDbConnection dbConn, IsolationLevel isolationLevel)
  • public static void CreateTable<T>(this IDbConnection dbConn)
  • public static void CreateTable<T>(this IDbConnection dbConn, bool overwrite)
  • public static void CreateTable(this IDbConnection dbConn, bool overwrite, Type modelType)
  • public static void CreateTableIfNotExists(this IDbConnection dbConn, Type[] tableTypes)
  • public static void CreateTableIfNotExists<T>(this IDbConnection dbConn)
  • public static void CreateTableIfNotExists(this IDbConnection dbConn, Type modelType)
  • public static void CreateTables(this IDbConnection dbConn, bool overwrite, Type[] tableTypes)
  • public static void Delete<T>(this IDbConnection dbConn, T[] objs)
  • public static void Delete<T>(this IDbConnection dbConn, string sqlFilter, object[] filterParams)
  • public static void Delete(this IDbConnection dbConn, Type tableType, string sqlFilter, object[] filterParams)
  • public static void DeleteAll<T>(this IDbConnection dbConn, IEnumerable<T> objs)
  • public static void DeleteAll<T>(this IDbConnection dbConn)
  • public static void DeleteAll(this IDbConnection dbConn, Type tableType)
  • public static void DeleteById<T>(this IDbConnection dbConn, object id)
  • public static void DeleteByIdParam<T>(this IDbConnection dbConn, object id)
  • public static void DeleteByIds<T>(this IDbConnection dbConn, IEnumerable idValues)
  • public static void DropAndCreateTable<T>(this IDbConnection dbConn)
  • public static void DropAndCreateTable(this IDbConnection dbConn, Type modelType)
  • public static void DropAndCreateTables(this IDbConnection dbConn, Type[] tableTypes)
  • public static void DropTable(this IDbConnection dbConn, Type modelType)
  • public static void DropTable<T>(this IDbConnection dbConn)
  • public static void DropTables(this IDbConnection dbConn, Type[] tableTypes)
  • public static void ExecuteProcedure<T>(this IDbConnection dbConn, T obj)
  • public static int ExecuteSql(this IDbConnection dbConn, string sql)
  • public static string GetLastSql(this IDbConnection dbConn)
  • public static void Insert<T>(this IDbConnection dbConn, T[] objs)
  • public static void InsertAll<T>(this IDbConnection dbConn, IEnumerable<T> objs)
  • public static void InsertParam<T>(this IDbConnection dbConn, T obj)
  • public static void Save<T>(this IDbConnection dbConn, T obj)
  • public static void Save<T>(this IDbConnection dbConn, T[] objs)
  • public static void SaveAll<T>(this IDbConnection dbConn, IEnumerable<T> objs)
  • public static bool TableExists(this IDbConnection dbConn, string tableName)
  • public static void Update<T>(this IDbConnection dbConn, T[] objs)
  • public static void UpdateAll<T>(this IDbConnection dbConn, IEnumerable<T> objs)
  • public static void UpdateParam<T>(this IDbConnection dbConn, T obj)
• public static class OrmLiteWriteExtensions
  • public static int GetColumnIndex(this IDataReader dataReader, string fieldName)
  • public static T PopulateWithSqlReader<T>(this T objWithProperties, IDataReader dataReader)
  • public static T PopulateWithSqlReader<T>(this T objWithProperties, IDataReader dataReader, FieldDefinition[] fieldDefs, Dictionary<string, int> indexCache)
• public class ParameterRebinder : ExpressionVisitor
  • public ParameterRebinder(Dictionary<ParameterExpression, ParameterExpression> map)
  • public static Expression ReplaceParameters(Dictionary<ParameterExpression, ParameterExpression> map, Expression exp)
• public class PartialSqlString
  • public string Text { get; set; }
  • public PartialSqlString(string text)
• public static class PredicateBuilder
  • public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
  • public static Expression<Func<T, bool>> Create<T>(Expression<Func<T, bool>> predicate)
  • public static Expression<Func<T, bool>> False<T>()
  • public static Expression<Func<T, bool>> Not<T>(this Expression<Func<T, bool>> expression)
  • public static Expression<Func<T, bool>> Or<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
  • public static Expression<Func<T, bool>> True<T>()
• public sealed delegate PropertyGetterDelegate : MulticastDelegate
  • public PropertyGetterDelegate(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object instance, AsyncCallback callback, object object)
  • public virtual object EndInvoke(IAsyncResult result)
  • public virtual object Invoke(object instance)
• public static class PropertyInvoker
  • public static PropertyGetterDelegate GetPropertyGetterFn(this PropertyInfo propertyInfo)
  • public static PropertySetterDelegate GetPropertySetterFn(this PropertyInfo propertyInfo)
• public sealed delegate PropertySetterDelegate : MulticastDelegate
  • public PropertySetterDelegate(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object instance, object value, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object instance, object value)
• public static class ReadConnectionExtensions
  • public static long Count<T>(this IDbConnection dbConn, SqlExpressionVisitor<T> expression)
  • public static long Count<T>(this IDbConnection dbConn, Expression<Func<T, bool>> expression)
  • public static long Count<T>(this IDbConnection dbConn)
  • public static SqlExpressionVisitor<T> CreateExpression<T>(this IDbConnection dbConn)
  • public static SqlExpressionVisitor<T> CreateExpression<T>()
  • public static T Exec<T>(this IDbConnection dbConn, Func<IDbCommand, T> filter)
  • public static void Exec(this IDbConnection dbConn, Action<IDbCommand> filter)
  • public static IEnumerable<T> ExecLazy<T>(this IDbConnection dbConn, Func<IDbCommand, IEnumerable<T>> filter)
  • public static T First<T>(this IDbConnection dbConn, Expression<Func<T, bool>> predicate)
  • public static T First<T>(this IDbConnection dbConn, SqlExpressionVisitor<T> expression)
  • public static T FirstOrDefault<T>(this IDbConnection dbConn, Expression<Func<T, bool>> predicate)
  • public static T FirstOrDefault<T>(this IDbConnection dbConn, SqlExpressionVisitor<T> expression)
  • public static IOrmLiteDialectProvider GetDialectProvider(this IDbConnection dbConn)
  • public static TKey GetScalar<T, TKey>(this IDbConnection dbConn, Expression<Func<T, TKey>> field)
  • public static TKey GetScalar<T, TKey>(this IDbConnection dbConn, Expression<Func<T, TKey>> field, Expression<Func<T, bool>> predicate)
  • public static IDbTransaction OpenTransaction(this IDbConnection dbConn)
  • public static IDbTransaction OpenTransaction(this IDbConnection dbConn, IsolationLevel isolationLevel)
  • public static List<T> Select<T>(this IDbConnection dbConn, Expression<Func<T, bool>> predicate)
  • public static List<T> Select<T>(this IDbConnection dbConn, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> expression)
  • public static List<T> Select<T>(this IDbConnection dbConn, SqlExpressionVisitor<T> expression)
  • public static List<T> SelectParam<T>(this IDbConnection dbConn, Expression<Func<T, bool>> predicate)
• public static class ReadExtensions
  • public static long Count<T>(this IDbCommand dbCmd)
  • public static long Count<T>(this IDbCommand dbCmd, SqlExpressionVisitor<T> expression)
  • public static long Count<T>(this IDbCommand dbCmd, Expression<Func<T, bool>> predicate)
  • public static SqlExpressionVisitor<T> CreateExpression<T>()
  • public static T First<T>(this IDbCommand dbCmd, Expression<Func<T, bool>> predicate)
  • public static T First<T>(this IDbCommand dbCmd, SqlExpressionVisitor<T> expression)
  • public static T FirstOrDefault<T>(this IDbCommand dbCmd, Expression<Func<T, bool>> predicate)
  • public static T FirstOrDefault<T>(this IDbCommand dbCmd, SqlExpressionVisitor<T> expression)
  • public static TKey GetScalar<T, TKey>(this IDbCommand dbCmd, Expression<Func<T, TKey>> field)
  • public static TKey GetScalar<T, TKey>(this IDbCommand dbCmd, Expression<Func<T, TKey>> field, Expression<Func<T, bool>> predicate)
  • public static List<T> Select<T>(this IDbCommand dbCmd, Expression<Func<T, bool>> predicate)
  • public static List<T> Select<T>(this IDbCommand dbCmd, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> expression)
  • public static List<T> Select<T>(this IDbCommand dbCmd, SqlExpressionVisitor<T> expression)
  • public static List<T> SelectParam<T>(this IDbCommand dbCmd, Expression<Func<T, bool>> predicate)
• public class ReflectionPropertyInvoker : IPropertyInvoker
  • public static readonly ReflectionPropertyInvoker Instance
  • public Func<object, Type, object> ConvertValueFn { get; set; }
  • public ReflectionPropertyInvoker()
  • public object GetPropertyValue(PropertyInfo propertyInfo, object fromInstance)
  • public void SetPropertyValue(PropertyInfo propertyInfo, Type fieldType, object onInstance, object withValue)
• public class SchemaAttribute : Attribute
  • public string Name { get; set; }
  • public SchemaAttribute(string name)
• public static class Sql
  • public static string As<T>(T value, object asValue)
  • public static T Avg<T>(T value)
  • public static T Count<T>(T value)
  • public static string Desc<T>(T value)
  • public static List<object> Flatten(IEnumerable list)
  • public static bool In<T, TItem>(T value, TItem[] list)
  • public static T Max<T>(T value)
  • public static T Min<T>(T value)
  • public static T Sum<T>(T value)
• public class SqlBuilder
  • public class Template
  • public SqlBuilder()
  • public SqlBuilder AddParameters(object parameters)
  • public Template AddTemplate(string sql, object parameters = null)
  • public SqlBuilder Join(string sql, object parameters = null)
  • public SqlBuilder LeftJoin(string sql, object parameters = null)
  • public SqlBuilder OrderBy(string sql, object parameters = null)
  • public SqlBuilder Select(string sql, object parameters = null)
  • public SqlBuilder Where(string sql, object parameters = null)
• public abstract class SqlExpressionVisitor<T>
  • public Dictionary<string, object> Params
  • public string GroupByExpression { get; set; }
  • public string HavingExpression { get; set; }
  • public IList<string> InsertFields { get; set; }
  • public bool IsParameterized { get; set; }
  • public virtual string LimitExpression { get; }
  • public string OrderByExpression { get; set; }
  • public bool PrefixFieldWithTableName { get; set; }
  • public int? Rows { get; set; }
  • public string SelectExpression { get; set; }
  • protected string Sep { get; }
  • public int? Skip { get; set; }
  • public IList<string> UpdateFields { get; set; }
  • public string WhereExpression { get; set; }
  • public bool WhereStatementWithoutWhereString { get; set; }
  • public SqlExpressionVisitor()
  • protected static object GetQuotedFalseValue()
  • protected static object GetQuotedTrueValue()
  • public virtual SqlExpressionVisitor<T> And(Expression<Func<T, bool>> predicate)
  • protected virtual string ApplyPaging(string sql)
  • protected virtual string BindOperant(ExpressionType e)
  • public IList<string> GetAllFields()
  • protected object GetFalseExpression()
  • protected virtual string GetQuotedColumnName(string memberName)
  • protected object GetTrueExpression()
  • public virtual SqlExpressionVisitor<T> GroupBy()
  • public virtual SqlExpressionVisitor<T> GroupBy(string groupBy)
  • public virtual SqlExpressionVisitor<T> GroupBy<TKey>(Expression<Func<T, TKey>> keySelector)
  • public virtual SqlExpressionVisitor<T> Having()
  • public virtual SqlExpressionVisitor<T> Having(string sqlFilter, object[] filterParams)
  • public virtual SqlExpressionVisitor<T> Having(Expression<Func<T, bool>> predicate)
  • public virtual SqlExpressionVisitor<T> Insert<TKey>(Expression<Func<T, TKey>> fields)
  • public virtual SqlExpressionVisitor<T> Insert(IList<string> insertFields)
  • public virtual SqlExpressionVisitor<T> Insert()
  • protected bool IsFieldName(object quotedExp)
  • public virtual SqlExpressionVisitor<T> Limit(int skip, int rows)
  • public virtual SqlExpressionVisitor<T> Limit(int rows)
  • public virtual SqlExpressionVisitor<T> Limit()
  • public virtual SqlExpressionVisitor<T> Or(Expression<Func<T, bool>> predicate)
  • public virtual SqlExpressionVisitor<T> OrderBy()
  • public virtual SqlExpressionVisitor<T> OrderBy(string orderBy)
  • public virtual SqlExpressionVisitor<T> OrderBy<TKey>(Expression<Func<T, TKey>> keySelector)
  • public virtual SqlExpressionVisitor<T> OrderByDescending<TKey>(Expression<Func<T, TKey>> keySelector)
  • protected string RemoveQuoteFromAlias(string exp)
  • public virtual SqlExpressionVisitor<T> Select()
  • public virtual SqlExpressionVisitor<T> Select(string selectExpression)
  • public virtual SqlExpressionVisitor<T> Select<TKey>(Expression<Func<T, TKey>> fields)
  • public virtual SqlExpressionVisitor<T> SelectDistinct<TKey>(Expression<Func<T, TKey>> fields)
  • public virtual SqlExpressionVisitor<T> ThenBy<TKey>(Expression<Func<T, TKey>> keySelector)
  • public virtual SqlExpressionVisitor<T> ThenByDescending<TKey>(Expression<Func<T, TKey>> keySelector)
  • public virtual string ToCountStatement()
  • public virtual string ToDeleteRowStatement()
  • public virtual string ToSelectStatement()
  • public virtual string ToUpdateStatement(T item, bool excludeDefaults = false)
  • public virtual SqlExpressionVisitor<T> Update(IList<string> updateFields)
  • public virtual SqlExpressionVisitor<T> Update<TKey>(Expression<Func<T, TKey>> fields)
  • public virtual SqlExpressionVisitor<T> Update()
  • protected virtual object VisitArrayMethodCall(MethodCallExpression m)
  • protected virtual object VisitBinary(BinaryExpression b)
  • protected virtual object VisitColumnAccessMethod(MethodCallExpression m)
  • protected virtual object VisitConstant(ConstantExpression c)
  • protected virtual List<object> VisitExpressionList(ReadOnlyCollection<Expression> original)
  • protected virtual object VisitLambda(LambdaExpression lambda)
  • protected virtual object VisitMemberAccess(MemberExpression m)
  • protected virtual object VisitMemberInit(MemberInitExpression exp)
  • protected virtual object VisitMethodCall(MethodCallExpression m)
  • protected virtual object VisitNew(NewExpression nex)
  • protected virtual object VisitNewArray(NewArrayExpression na)
  • protected virtual List<object> VisitNewArrayFromExpressionList(NewArrayExpression na)
  • protected virtual object VisitParameter(ParameterExpression p)
  • protected virtual object VisitSqlMethodCall(MethodCallExpression m)
  • protected virtual object VisitUnary(UnaryExpression u)
  • public virtual SqlExpressionVisitor<T> Where()
  • public virtual SqlExpressionVisitor<T> Where(string sqlFilter, object[] filterParams)
  • public virtual SqlExpressionVisitor<T> Where(Expression<Func<T, bool>> predicate)
• public class SqlInValues
  • public int Count { get; }
  • public SqlInValues(IEnumerable values)
  • public string ToSqlInString()
• public static class WriteConnectionExtensions
  • public static int Delete<T>(this IDbConnection dbConn, Expression<Func<T, bool>> where)
  • public static int Delete<T>(this IDbConnection dbConn, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> where)
  • public static int Delete<T>(this IDbConnection dbConn, SqlExpressionVisitor<T> where)
  • public static int Delete<T>(this IDbConnection dbConn, string where = null)
  • public static int Delete(this IDbConnection dbConn, string table = null, string where = null)
  • public static void InsertOnly<T>(this IDbConnection dbConn, T obj, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> onlyFields)
  • public static void InsertOnly<T>(this IDbConnection dbConn, T obj, SqlExpressionVisitor<T> onlyFields)
  • public static int Update<T>(this IDbConnection dbConn, T item, Expression<Func<T, bool>> where)
  • public static int Update<T>(this IDbConnection dbConn, object updateOnly, Expression<Func<T, bool>> where = null)
  • public static int Update<T>(this IDbConnection dbConn, string set = null, string where = null)
  • public static int Update(this IDbConnection dbConn, string table = null, string set = null, string where = null)
  • public static int UpdateNonDefaults<T>(this IDbConnection dbConn, T item, Expression<Func<T, bool>> where)
  • public static int UpdateOnly<T>(this IDbConnection dbConn, T model, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> onlyFields)
  • public static int UpdateOnly<T>(this IDbConnection dbConn, T model, SqlExpressionVisitor<T> onlyFields)
  • public static int UpdateOnly<T, TKey>(this IDbConnection dbConn, T obj, Expression<Func<T, TKey>> onlyFields = null, Expression<Func<T, bool>> where = null)
• public static class WriteExtensions
  • public static int Delete<T>(this IDbCommand dbCmd, Expression<Func<T, bool>> where)
  • public static int Delete<T>(this IDbCommand dbCmd, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> where)
  • public static int Delete<T>(this IDbCommand dbCmd, SqlExpressionVisitor<T> where)
  • public static int Delete<T>(this IDbCommand dbCmd, string where = null)
  • public static int Delete(this IDbCommand dbCmd, string table = null, string where = null)
  • public static void InsertOnly<T>(this IDbCommand dbCmd, T obj, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> onlyFields)
  • public static void InsertOnly<T>(this IDbCommand dbCmd, T obj, SqlExpressionVisitor<T> onlyFields)
  • public static int Update<T>(this IDbCommand dbCmd, T item, Expression<Func<T, bool>> where)
  • public static int Update<T>(this IDbCommand dbCmd, object updateOnly, Expression<Func<T, bool>> where = null)
  • public static int Update<T>(this IDbCommand dbCmd, string set = null, string where = null)
  • public static int Update(this IDbCommand dbCmd, string table = null, string set = null, string where = null)
  • public static int UpdateNonDefaults<T>(this IDbCommand dbCmd, T item, Expression<Func<T, bool>> where)
  • public static int UpdateOnly<T>(this IDbCommand dbCmd, T model, Func<SqlExpressionVisitor<T>, SqlExpressionVisitor<T>> onlyFields)
  • public static int UpdateOnly<T>(this IDbCommand dbCmd, T model, SqlExpressionVisitor<T> onlyFields)
  • public static int UpdateOnly<T, TKey>(this IDbCommand dbCmd, T obj, Expression<Func<T, TKey>> onlyFields = null, Expression<Func<T, bool>> where = null)

ServiceStack.OrmLite.MySql

• public class MySqlExpression<T> : SqlExpression<T>
• public class MySqlExpressionVisitor<T> : SqlExpressionVisitor<T>
  • public MySqlExpressionVisitor()