• SnapObjects .NET API Documentation

    This site offers links to all the available documents related to SnapObjects .NET development. If you want to find the documents of the other Appeon products (PowerBuilder IDE, SnapDevelop, DataWindow Converter, PowerScript Migrator, PowerServer, and InfoMaker), go to the Appeon Documentation Center.

    SnapObjects .NET API

    Getting Started:

    Features List of SnapObjects 2.x (see New or Changed APIs)

    Installation Guide of SnapObjects 2.x

    Release Bulletin of SnapObjects 2.x

    API Reference:

    SnapObjects .NET API Reference (2.1.0) (2.0.0) (1.0.x)

    Tutorials:

    CRUD Operations with SqlModelMapper

    Add Data Validation to SqlModelMapper

    Developer Guides:

    Working with Transactions in SnapObjects

    Using Nested Models in SqlModelMapper

    Tracking Actions with SqlModelMapper

    Type-Safe Queries Using SnapObjects API

  • SnapObjects.Data 2.0.0
  • Attributes for Model Class and Property
  • Class
  • SqlSelectAttribute
  • Constructors
  • SqlSelectAttribute

    Show / Hide Table of Contents
    • Readme First!
    • SnapObjects.Data 2.0.0
      • Attributes for Model Class and Property
        • Class
          • DistinctAttribute
            • Constructors
              • DistinctAttribute
          • FromTableAttribute
            • Constructors
              • FromTableAttribute
                • FromTableAttribute(String)
                • FromTableAttribute(String, String)
            • Properties
              • Alias
              • AliasDefined
              • Name
              • Schema
              • WhereRaw
          • JoinTableAttribute
            • Constructors
              • JoinTableAttribute
                • JoinTableAttribute(String)
                • JoinTableAttribute(String, String)
            • Properties
              • Alias
              • AliasDefined
              • JoinType
              • Name
              • OnRaw
              • Schema
          • SqlAndHavingAttribute
            • Constructors
              • SqlAndHavingAttribute
                • SqlAndHavingAttribute(String)
                • SqlAndHavingAttribute(String, String)
            • Properties
              • Left
              • Operator
              • RawCondition
              • RawConditionDefined
              • Right
          • SqlAndWhereAttribute
            • Constructors
              • SqlAndWhereAttribute
                • SqlAndWhereAttribute(String)
                • SqlAndWhereAttribute(String, String)
            • Properties
              • Left
              • Operator
              • RawCondition
              • RawConditionDefined
              • Right
          • SqlGroupByAttribute
            • Constructors
              • SqlGroupByAttribute
            • Properties
              • GroupByExpressions
          • SqlHavingAttribute
            • Constructors
              • SqlHavingAttribute
                • SqlHavingAttribute(String)
                • SqlHavingAttribute(String, String)
            • Properties
              • Left
              • Operator
              • RawCondition
              • RawConditionDefined
              • Right
          • SqlOrderByAttribute
            • Constructors
              • SqlOrderByAttribute
            • Properties
              • OrderByExpressions
          • SqlOrHavingAttribute
            • Constructors
              • SqlOrHavingAttribute
                • SqlOrHavingAttribute(String)
                • SqlOrHavingAttribute(String, String)
            • Properties
              • Left
              • Operator
              • RawCondition
              • RawConditionDefined
              • Right
          • SqlOrWhereAttribute
            • Constructors
              • SqlOrWhereAttribute
                • SqlOrWhereAttribute(String)
                • SqlOrWhereAttribute(String, String)
            • Properties
              • Left
              • Operator
              • RawCondition
              • RawConditionDefined
              • Right
          • SqlParameterAttribute
            • Constructors
              • SqlParameterAttribute
            • Properties
              • DataType
              • Direction
              • Name
          • SqlSelectAttribute
            • Constructors
              • SqlSelectAttribute
            • Properties
              • RawSelect
              • SelectName
          • SqlUnionAttribute
            • Constructors
              • SqlUnionAttribute
                • SqlUnionAttribute(String)
                • SqlUnionAttribute(Type)
                • SqlUnionAttribute(Type, String)
            • Properties
              • IsRawSql
              • ModelType
              • RawSql
              • SelectName
              • UnionAll
          • SqlWhereAttribute
            • Constructors
              • SqlWhereAttribute
                • SqlWhereAttribute(String)
                • SqlWhereAttribute(String, String)
            • Properties
              • Left
              • Operator
              • RawCondition
              • RawConditionDefined
              • Right
          • SubQueryAttribute
            • Constructors
              • SubQueryAttribute
                • SubQueryAttribute(String, String)
                • SubQueryAttribute(String, Type)
                • SubQueryAttribute(String, Type, String)
            • Properties
              • IsRawSql
              • ModelType
              • Name
              • RawSql
              • SelectName
          • TopAttribute
            • Constructors
              • TopAttribute
            • Properties
              • TopRows
          • UpdateWhereStrategyAttribute
            • Constructors
              • UpdateWhereStrategyAttribute
            • Properties
              • UpdateWhereStrategy
        • Properties
          • DefaultValueAttribute
          • IdentityAttribute
          • ModelEmbeddedAttribute
            • Constructors
              • ModelEmbeddedAttribute
            • Properties
              • CascadeCreate
              • CascadeDelete
              • ModelType
              • ParamValue
              • QueryExpression
              • QuerySelector
          • PropertySaveAttribute
            • Constructors
              • PropertySaveAttribute
            • Properties
              • SaveStrategy
          • SetValueAttribute
            • Constructors
              • SetValueAttribute
                • SetValueAttribute(String, String)
                • SetValueAttribute(String, String, SetValueStrategy)
                • SetValueAttribute(String, String, SetValueStrategy, ModelSelector)
            • Properties
              • ModelSelector
              • SetValueStrategy
              • Source
              • Target
          • SqlColumnAttribute
            • Constructors
              • SqlColumnAttribute
                • SqlColumnAttribute(String)
                • SqlColumnAttribute(String, String)
                • SqlColumnAttribute(String, String, String)
            • Properties
              • Column
              • ColumnAlias
              • ColumnAliasDefined
              • Order
              • TableAlias
              • TableAliasDefined
              • TypeName
          • SqlComputeAttribute
            • Constructors
              • SqlComputeAttribute
                • SqlComputeAttribute(String)
                • SqlComputeAttribute(String, String)
            • Properties
              • Alias
              • AliasDefined
              • Expression
              • Order
              • TypeName
          • SqlDefaultValueAttribute
            • Constructors
              • SqlDefaultValueAttribute
            • Properties
              • DefaultValue
          • SqlEmbeddedAttribute
            • Constructors
              • SqlEmbeddedAttribute
            • Properties
              • ParamValue
              • RawSql
      • SqlModelMapper
        • IDetailTracker
          • Properties
            • MasterModel
          • Methods
            • SaveChanges
            • TrackDetail
            • TrackDetails
            • TrackGrandDetail
            • TrackGrandDetails
        • IEmbeddedLoadable
          • Properties
            • MasterModel
          • Methods
            • Include
            • IncludeAll
        • ILoadable
          • Methods
            • FirstOrDefault
            • Include
              • Include(Expression<Func<TModel, object>>, Boolean)
              • Include(Int, Expression<Func<TModel, object>>, Boolean)
            • IncludeAll
              • IncludeAll(Boolean)
              • IncludeAll(Int, Boolean)
            • ToArray
            • ToDictionary
            • ToList
        • ISqlModelMapper
          • Methods
            • Avg
            • ClearTracked
            • Count
            • DistinctCount
            • Exists
            • KeyExists
            • Load
              • Load<T>(Object[])
              • Load<T>(ISqlQueryBuilder, Object[])
            • LoadAll
            • LoadAllByPage
            • LoadByKey
            • LoadByPage
            • LoadEmbedded
            • Max
            • Min
            • RemoveTrackedModel
            • SaveChanges
            • Scalar
            • ScalarByKey
            • Sum
            • Track
              • Track(Action<ISaveContext>)
              • Track<T>(IModelEntry<TModel>)
              • Track<T>(IModelEntry<TModel>, Action<ISaveContext>)
              • Track(IMapperTrackable, params object[])
            • TrackCreate
              • TrackCreate<T>(TModel)
              • TrackCreate<T>(TModel, Action<ISaveContext>)
            • TrackCreateRange
            • TrackDelete
              • TrackDelete<T>(TModel)
              • TrackDelete<T>(TModel, Action<ISaveContext>)
            • TrackDeleteByKey
            • TrackDeleteRange
            • TrackMaster
              • TrackMaster<T>(IModelEntry<TModel>)
              • TrackMaster<T>(IModelEntry<TModel>, Action<ISaveContext>)
            • TrackRange
            • TrackSqlBuilder
              • TrackSqlBuilder(ISqlInsertBuilder, Object[])
              • TrackSqlBuilder(ISqlDeleteBuilder, Object[])
              • TrackSqlBuilder(ISqlUpdateBuilder, Object[])
            • TrackSqlCUD
            • TrackUpdate
              • TrackUpdate<T>(TModel)
              • TrackUpdate<T>(TModel, Action<ISaveContext>)
              • TrackUpdate<T>(TModel, TModel)
              • TrackUpdate<T>(TModel, TModel, Action<ISaveContext>)
            • TrackUpdateRange
            • ValidateTrackedModels
              • ValidateTrackedModels()
              • ValidateTrackedModels(List<ValidationResult>)
        • SqlModelMapper
          • Constructors
            • SqlModelMapper
      • SqlBuilder
        • ISqlBuilder
          • Methods
            • AddParameters
            • Clone
            • GetParameterPlacehold
            • Reset
            • ToReadOnly
        • ISqlBuilderBase
          • Properties
            • Name
            • SqlType
            • UsedParameters
          • Methods
            • ToSqlString
            • Validate
        • ISqlBuilderCache
          • Methods
            • Get
            • GetModifiable
            • Set
        • ISqlConditionBuilder
          • Properties
            • UsedParameters
          • Methods
            • ToSqlString
        • ISqlDeleteBuilder
          • Methods
            • Delete
              • Delete(String)
              • Delete(String, String)
        • ISqlFromBuilder
          • Properties
            • HasTable
          • Methods
            • AsJoin
            • From
              • From(ISqlBuilder, String)
              • From(String)
              • From(String, String)
              • From(String, String, String)
            • FromRaw
              • FromRaw(String)
              • FromRaw(String, String)
            • GetTableAlias
        • ISqlGroupBuilder
          • Methods
            • AsHaving
            • GroupBy
              • GroupBy(String[])
              • GroupBy(String)
        • ISqlHavingAndOr
        • ISqlHavingAndOr<TBuilder>
          • Methods
            • AndHaving
              • AndHaving(String, ISqlParameter)
              • AndHaving(String, SqlBinaryOperator, ISqlParameter)
              • AndHaving(String, String)
              • AndHaving(String, SqlBinaryOperator, String)
              • AndHaving(String, ISqlBuilder)
              • AndHaving(String, SqlBinaryOperator, ISqlBuilder)
              • AndHaving(ISqlJoinCondition)
            • AndHavingRaw
              • AndHavingRaw(String, ISqlParameter[])
              • AndHavingRaw(String, String, ISqlParameter[])
            • AndHavingValue
              • AndHavingValue(String, Object)
              • AndHavingValue(String, SqlBinaryOperator, Object)
            • OrHaving
              • OrHaving(String, ISqlParameter)
              • OrHaving(String, SqlBinaryOperator, ISqlParameter)
              • OrHaving(String, String)
              • OrHaving(String, SqlBinaryOperator, String)
              • OrHaving(String, ISqlBuilder)
              • OrHaving(String, SqlBinaryOperator, ISqlBuilder)
              • OrHaving(ISqlHavingCondition)
            • OrHavingRaw
              • OrHavingRaw(String, ISqlParameter[])
              • OrHavingRaw(String, String, ISqlParameter[])
            • OrHavingValue
              • OrHavingValue(String, Object)
              • OrHavingValue(String, SqlBinaryOperator, Object)
        • ISqlHavingBuilder
          • Methods
            • AsOrderBy
            • Having
              • Having(String, ISqlParameter)
              • Having(String, SqlBinaryOperator, ISqlParameter)
              • Having(String, String)
              • Having(String, SqlBinaryOperator, String)
              • Having(String, ISqlBuilder)
              • Having(String, SqlBinaryOperator, ISqlBuilder)
              • Having(ISqlHavingCondition)
              • Having(ISqlHavingCondition, String)
            • HavingRaw
              • HavingRaw(String, ISqlParameter[])
              • HavingRaw(String, String, ISqlParameter[])
            • HavingValue
              • HavingValue(String, Object)
              • HavingValue(String, SqlBinaryOperator, Object)
        • ISqlHavingCondition
        • ISqlInsertBuilder
          • Methods
            • Column
            • ColumnValue
            • Insert
              • Insert(String)
              • Insert(String, String)
        • ISqlJoinBuilder
          • Properties
            • HasJoin
            • HasOn
          • Methods
            • AsWhere
            • FullJoin
              • FullJoin(String)
              • FullJoin(String, String)
              • FullJoin(String, String, String)
              • FullJoin(ISqlBuilder, String)
            • FullJoinRaw
              • FullJoinRaw(String)
              • FullJoinRaw(String, String)
            • GetJoinType
            • InnerJoin
              • InnerJoin(String)
              • InnerJoin(String, String)
              • InnerJoin(String, String, String)
              • InnerJoin(ISqlBuilder, String)
            • InnerJoinRaw
              • InnerJoinRaw(String)
              • InnerJoinRaw(String, String)
            • Join
              • Join(String)
              • Join(String, String)
              • Join(String, String, String)
              • Join(ISqlBuilder, String)
            • JoinRaw
              • JoinRaw(String)
              • JoinRaw(String, String)
            • LeftJoin
              • LeftJoin(String)
              • LeftJoin(String, String)
              • LeftJoin(String, String, String)
              • LeftJoin(ISqlBuilder, String)
            • LeftJoinRaw
              • LeftJoinRaw(String)
              • LeftJoinRaw(String, String)
            • RightJoin
              • RightJoin(String)
              • RightJoin(String, String)
              • RightJoin(String, String, String)
              • RightJoin(ISqlBuilder, String)
            • RightJoinRaw
              • RightJoinRaw(String)
              • RightJoinRaw(String, String)
        • ISqlJoinCondition
        • ISqlJoinOnAndOr
        • ISqlJoinOnAndOr<TBuilder>
          • Properties
            • HasOn
          • Methods
            • AndOn
              • AndOn(String, String)
              • AndOn(String, SqlBinaryOperator, String)
              • AndOn(String, ISqlParameter)
              • AndOn(String, SqlBinaryOperator, ISqlParameter)
              • AndOn(String, ISqlBuilder)
              • AndOn(String, SqlBinaryOperator, ISqlBuilder)
              • AndOn(ISqlJoinCondition)
            • AndOnRaw
            • AndOnValue
              • AndOnValue(String, Object)
              • AndOnValue(String, SqlBinaryOperator, Object)
            • OrOn
              • OrOn(String, String)
              • OrOn(String, SqlBinaryOperator, String)
              • OrOn(String, ISqlParameter)
              • OrOn(String, SqlBinaryOperator, ISqlParameter)
              • OrOn(String, ISqlBuilder)
              • OrOn(String, SqlBinaryOperator, ISqlBuilder)
              • OrOn(ISqlJoinCondition)
            • OrOnRaw
            • OrOnValue
              • OrOnValue(String, Object)
              • OrOnValue(String, SqlBinaryOperator, Object)
        • ISqlJoinOnBuilder
          • Methods
            • On
              • On(String, String)
              • On(String, SqlBinaryOperator, String)
              • On(String, ISqlParameter)
              • On(String, SqlBinaryOperator, ISqlParameter)
              • On(String, ISqlBuilder)
              • On(String, SqlBinaryOperator, ISqlBuilder)
              • On(ISqlJoinCondition)
            • OnRaw
            • OnValue
              • OnValue(String, Object)
              • OnValue(String, SqlBinaryOperator, Object)
        • ISqlOrderBuilder
          • Methods
            • OrderByAscending
            • OrderByDescending
            • OrderByRaw
              • OrderByRaw(String)
              • OrderByRaw(String, String)
        • ISqlOrderThenBuilder
          • Methods
            • ThenByAscending
            • ThenByDescending
            • ThenByRaw
              • ThenByRaw(String)
              • ThenByRaw(String, String)
        • ISqlQueryBuilder
          • Methods
            • Distinct
            • Page
            • RemoveSelect
            • ReplaceSelect
            • Select
              • Select(ISqlBuilder)
              • Select(ISqlBuilder, String)
              • Select(String)
              • Select(String[])
              • Select(String, String)
            • SelectRaw
              • SelectRaw(String, ISqlParameter[])
              • SelectRaw(String, String, ISqlParameter[])
            • Top
            • Union
              • Union(ISqlQueryBuilder)
              • Union(ISqlQueryBuilder, String)
              • Union(String)
              • Union(String, String)
            • UnionAll
              • UnionAll(ISqlQueryBuilder)
              • UnionAll(ISqlQueryBuilder, String)
              • UnionAll(String)
              • UnionAll(String, String)
        • ISqlRawBuilder
          • Methods
            • Raw
        • ISqlReadOnlyBuilder
        • ISqlUpdateBuilder
          • Methods
            • Set
              • Set(String, ISqlParameter)
              • Set(String, String)
              • Set(String, ISqlBuilder)
            • SetRaw
            • SetValue
            • Update
              • Update(String)
              • Update(String, String)
        • ISqlWhereAndOr
        • ISqlWhereAndOr<TBuilder>
          • Methods
            • AndWhere
              • AndWhere(String, ISqlParameter)
              • AndWhere(String, SqlBinaryOperator, ISqlParameter)
              • AndWhere(String, String)
              • AndWhere(String, SqlBinaryOperator, String)
              • AndWhere(String, ISqlBuilder)
              • AndWhere(String, SqlBinaryOperator, ISqlBuilder)
              • AndWhere(ISqlWhereCondition)
            • AndWhereExists
            • AndWhereIsNotNull
            • AndWhereIsNull
            • AndWhereNotExists
            • AndWhereRaw
            • AndWhereValue
              • AndWhereValue(String, Object)
              • AndWhereValue(String, SqlBinaryOperator, Object)
            • OrWhere
              • OrWhere(String, ISqlParameter)
              • OrWhere(String, SqlBinaryOperator, ISqlParameter)
              • OrWhere(String, String)
              • OrWhere(String, SqlBinaryOperator, String)
              • OrWhere(String, ISqlBuilder)
              • OrWhere(String, SqlBinaryOperator, ISqlBuilder)
              • OrWhere(ISqlWhereCondition)
            • OrWhereExists
            • OrWhereIsNotNull
            • OrWhereIsNull
            • OrWhereNotExists
            • OrWhereRaw
            • OrWhereValue
              • OrWhereValue(String, Object)
              • OrWhereValue(String, SqlBinaryOperator, Object)
        • ISqlWhereBuilder
          • Properties
            • HasWhere
          • Methods
            • AsGroupBy
            • RemoveWhere
              • RemoveWhere()
              • RemoveWhere(String)
            • Where
              • Where(String, String)
              • Where(String, SqlBinaryOperator, String)
              • Where(String, ISqlParameter)
              • Where(String, SqlBinaryOperator, ISqlParameter)
              • Where(String, ISqlBuilder)
              • Where(String, SqlBinaryOperator, ISqlBuilder)
              • Where(ISqlWhereCondition)
              • Where(ISqlWhereCondition, String)
            • WhereExists
            • WhereIsNotNull
            • WhereIsNull
            • WhereNotExists
            • WhereRaw
              • WhereRaw(String, ISqlParameter[])
              • WhereRaw(String, String, ISqlParameter[])
            • WhereValue
              • WhereValue(String, Object)
              • WhereValue(String, SqlBinaryOperator, Object)
        • ISqlWhereCondition
        • SqlBuilder
          • Methods
            • Delete
              • Delete(String)
              • Delete(String, String)
            • EmbeddedHaving
              • EmbeddedHaving(String, String)
              • EmbeddedHaving(String, SqlBinaryOperator, String)
              • EmbeddedHaving(String, ISqlParameter)
              • EmbeddedHaving(String, SqlBinaryOperator, ISqlParameter)
              • EmbeddedHaving(String, ISqlBuilder)
              • EmbeddedHaving(String, SqlBinaryOperator, ISqlBuilder)
            • EmbeddedHavingRaw
              • EmbeddedHavingRaw(String, ISqlParameter[])
              • EmbeddedHavingRaw(String, String, ISqlParameter[])
            • EmbeddedHavingValue
              • EmbeddedHavingValue(String, Object)
              • EmbeddedHavingValue(String, SqlBinaryOperator, Object)
            • EmbeddedOn
              • EmbeddedOn(String, String)
              • EmbeddedOn(String, SqlBinaryOperator, String)
              • EmbeddedOn(String, ISqlParameter)
              • EmbeddedOn(String, SqlBinaryOperator, ISqlParameter)
              • EmbeddedOn(String, ISqlBuilder)
              • EmbeddedOn(String, SqlBinaryOperator, ISqlBuilder)
            • EmbeddedOnRaw
              • EmbeddedOnRaw(String, ISqlParameter[])
              • EmbeddedOnRaw(String, String, ISqlParameter[])
            • EmbeddedOnValue
              • EmbeddedOnValue(String, Object)
              • EmbeddedOnValue(String, SqlBinaryOperator, Object)
            • EmbeddedWhere
              • EmbeddedWhere(String, String)
              • EmbeddedWhere(String, SqlBinaryOperator, String)
              • EmbeddedWhere(String, ISqlParameter)
              • EmbeddedWhere(String, SqlBinaryOperator, ISqlParameter)
              • EmbeddedWhere(String, ISqlBuilder)
              • EmbeddedWhere(String, SqlBinaryOperator, ISqlBuilder)
            • EmbeddedWhereExists
            • EmbeddedWhereIsNotNull
            • EmbeddedWhereIsNull
            • EmbeddedWhereNotExists
            • EmbeddedWhereRaw
              • EmbeddedWhereRaw(String, ISqlParameter[])
              • EmbeddedWhereRaw(String, String, ISqlParameter[])
            • EmbeddedWhereValue
              • EmbeddedWhereValue(String, Object)
              • EmbeddedWhereValue(String, SqlBinaryOperator, Object)
            • Having
              • Having(String, String)
              • Having(String, SqlBinaryOperator, String)
              • Having(String, ISqlParameter)
              • Having(String, SqlBinaryOperator, ISqlParameter)
              • Having(String, ISqlBuilder)
              • Having(String, SqlBinaryOperator, ISqlBuilder)
            • HavingRaw
              • HavingRaw(String, ISqlParameter[])
              • HavingRaw(String, String, ISqlParameter[])
            • HavingValue
              • HavingValue(String, Object)
              • HavingValue(String, SqlBinaryOperator, Object)
            • Insert
              • Insert(String)
              • Insert(String, String)
            • On
              • On(String, String)
              • On(String, SqlBinaryOperator, String)
              • On(String, ISqlParameter)
              • On(String, SqlBinaryOperator, ISqlParameter)
              • On(String, ISqlBuilder)
              • On(String, SqlBinaryOperator, ISqlBuilder)
            • OnRaw
              • OnRaw(String, ISqlParameter[])
              • OnRaw(String, String, ISqlParameter[])
            • OnValue
              • OnValue(String, Object)
              • OnValue(String, SqlBinaryOperator, Object)
            • Parameter
              • Parameter<TType>(String)
              • Parameter(Type, String)
            • Select
              • Select(String, String)
              • Select(String[])
              • Select(ISqlBuilder, String)
            • SelectRaw
            • Update
              • Update(String)
              • Update(String, String)
            • Where
              • Where(String, String)
              • Where(String, SqlBinaryOperator, String)
              • Where(String, ISqlParameter)
              • Where(String, SqlBinaryOperator, ISqlParameter)
              • Where(String, ISqlBuilder)
              • Where(String, SqlBinaryOperator, ISqlBuilder)
            • WhereExists
            • WhereIsNotNull
            • WhereIsNull
            • WhereNotExists
            • WhereRaw
              • WhereRaw(String, ISqlParameter[])
              • WhereRaw(String, String, ISqlParameter[])
            • WhereValue
              • WhereValue(String, Object)
              • WhereValue(String, SqlBinaryOperator, Object)
        • SqlBuilderBase
          • Constructors
            • SqlBuilderBase
        • SqlBuilderFactory
          • Properties
            • Cache
          • Methods
            • Create
        • SqlDeleteBuilder
          • Constructors
            • SqlDeleteBuilder
        • SqlInsertBuilder
          • Constructors
            • SqlInsertBuilder
        • SqlQueryBuilder
          • Constructors
            • SqlQueryBuilder
        • SqlRawBuilder
          • Constructors
            • SqlRawBuilder
        • SqlStatementType
        • SqlUpdateBuilder
          • Constructors
            • SqlUpdateBuilder
      • SqlExecutor
        • ILazyQueryable<T>
        • SqlExecutor
          • Constructors
            • SqlExecutor
        • ISqlExecutor
          • Properties
            • DataContext
          • Methods
            • Execute
            • ExecuteProcedure
            • Scalar
              • Scalar<TValue>(String, Object[])
              • Scalar<TValue>(ISqlQueryBuilder, Object[])
            • Select
              • Select<T>(String, Object[])
              • Select<T>(ISqlQueryBuilder, Object[])
            • SelectLazy
              • SelectLazy<T>(String, Object[])
              • SelectLazy<T>(ISqlQueryBuilder, Object[])
            • SelectOne
              • SelectOne<T>(String, Object[])
              • SelectOne<T>(ISqlQueryBuilder, Object[])
            • SelectProcedure
      • ChangeTrackingStrategy
      • DatabaseType
      • DataContext
        • Constructors
          • DataContext
            • DataContext(IDataContextOptions)
            • DataContext(DbConnection, IDataContextOptions)
        • Properties
          • ContextOptions
          • CurrentConnection
          • CurrentTransaction
          • SqlModelMapper
          • SqlExecutor
        • Methods
          • BeginTransaction
            • BeginTransaction()
            • BeginTransaction(IsolationLevel)
          • Commit
          • Rollback
          • UseTransaction
      • DataFormat
      • DataPacker
        • Constructors
          • DataPacker
      • DataTableExtensions
        • Methods
          • ExportJson
            • ExportJson(DataTable)
            • ExportJson(DataTable, Bool)
            • ExportJson(DataTable, Int)
            • ExportJson(DataTable, Int, Int)
            • ExportJson(DataTable, Int, Int, Short)
            • ExportJson(DataTable, Int, Int, Short, Short)
          • ExportXml
            • ExportXml(DataTable)
            • ExportXml(DataTable, Bool)
            • ExportXml(DataTable, Int)
            • ExportXml(DataTable, Int, Int)
            • ExportXml(DataTable, Int, Int, Short)
            • ExportXml(DataTable, Int, Int, Short, Short)
          • ImportJson
            • ImportJson(DataTable, String)
            • ImportJson(DataTable, String, Int)
            • ImportJson(DataTable, String, Int, Int)
            • ImportJson(DataTable, String, Int, Int, Short)
            • ImportJson(DataTable, String, Int, Int, Short, Short)
          • ImportJsonByKey
            • ImportJsonByKey(DataTable, String)
            • ImportJsonByKey(DataTable, String, Int)
            • ImportJsonByKey(DataTable, String, Int, Int)
          • ImportXml
            • ImportXml(DataTable, String)
            • ImportXml(DataTable, String, Int)
            • ImportXml(DataTable, String, Int, Int)
            • ImportXml(DataTable, String, Int, Int, Short)
            • ImportXml(DataTable, String, Int, Int, Short, Short)
          • ImportXmlByKey
            • ImportXmlByKey(DataTable, String)
            • ImportXmlByKey(DataTable, String, Int)
            • ImportXmlByKey(DataTable, String, Int, Int)
      • DataUnPacker
        • Constructors
          • DataUnPacker
      • DynamicModel
        • Properties
          • Item
            • Item[Int32]
            • Item[String]
          • Properties
          • PropertiesCount
        • Methods
          • Clone
          • CopyFrom
            • CopyFrom(DynamicModel)
            • CopyFrom(DynamicModel, Int, Int)
          • GetValue
            • GetValue(Int)
            • GetValue<TValue>(Int)
            • GetValue(String)
            • GetValue<TValue>(String)
          • IndexOf
          • SetValue
            • SetValue(Int, Object)
            • SetValue(String, Object)
          • SetValues
      • IAdoDbConnection
        • Properties
          • ConnectionId
          • ConnectionString
          • CurrentTransaction
          • DbConnection
        • Methods
          • Close
          • Open
      • IAdoDbTransaction
        • Properties
          • DbTransaction
          • TransactionId
        • Methods
          • Commit
          • Rollback
      • IAdoDbTransactionManager
        • Methods
          • BeginTransaction
            • BeginTransaction()
            • BeginTransaction(IsolationLevel)
          • UseTransaction
      • ICloneable
        • Methods
          • Clone
      • IDataContextOptions
        • Properties
          • BatchExecuting
          • CommandTimeout
          • ConnectionString
          • DatabaseType
          • IsolationLevel
      • IDataIncludeGetter<T>
        • Methods
          • FirstOrDefault
          • Include
          • IncludeAll
          • ToList
      • IDataIncludeSetter<T>
        • Methods
          • Include
          • IncludeAll
      • IDataPacker
        • Properties
          • Count
          • Keys
        • Methods
          • AddDataTable
            • AddDataTable(IDataPacker, String, DataTable)
            • AddDataTable(IDataPacker, String, DataTable, Boolean)
          • AddModel
          • AddModelEntries
          • AddModels
          • AddRaw
          • AddValue
          • ContainsKey
          • GetTextString
          • RemoveKey
      • IDataUnPacker
        • Properties
          • Count
          • DataFormat
          • Keys
          • Raw
        • Methods
          • ContainsKey
          • GetDataTable
            • GetDataTable(IDataUnpacker, String)
            • GetDataTable(IDataUnpacker, String, MappingMethod)
          • GetModel
          • GetModelEntries
            • GetModelEntries<T>(IDataUnpacker, String)
            • GetModelEntries<T>(IDataUnpacker, String, MappingMethod)
          • GetModels
          • GetRaw
          • RemoveKey
      • IDBResult
        • Properties
          • AffectedCount
          • Cancelled
          • DeletedCount
          • InsertedCount
          • ModifiedCount
      • IModelEntry
        • Properties
          • ModelState
          • Properties
        • Methods
          • GetCurrentValue
          • GetOriginalValue
          • GetPropertyState
          • SetCurrentValue
        • Events
          • CurrentValueChanged
      • IModelEntry<T>
      • IPropertyInfo
        • Properties
          • DataType
          • Index
          • Name
      • ISaveContext
        • Properties
          • Count
          • LastDbResult
          • Names
        • Methods
          • Add
          • CancelSave
          • Contains
          • Get
          • Remove
          • RemoveAll
      • ISqlParameter
        • Properties
          • DataType
          • Direction
          • Name
      • MappingMethod
      • ModelSelector
      • ModelSqlBuilder
        • Properties
          • DeleteBuilder
          • DeleteSql
          • QueryBuilder
          • QuerySql
        • Methods
          • GetBuilder
          • GetQueryBuilder
          • GetQuerySql
      • ModelState
      • ParamValue
        • Properties
          • DataType
          • Direction
          • Name
          • Value
        • Methods
          • New
            • New(String, Object)
            • New<Type>(String, Object, ParameterDirection)
            • New<Type>(String, ParameterDirection)
      • PropertiesState
      • QuerySelector
      • SaveStrategy
      • SetValueStrategy
      • SQLBinaryOperator
      • SqlJoinType
      • StateTrackable
      • UpdateSqlStrategy
      • UpdateWhereStrategy
    • SnapObjects.Data.AspNetCore 2.0.0
      • CommitPolicy
      • IRollbackResult
      • RollbackResult
        • Constructors
          • RollbackResult
        • Methods
          • ExecuteResult
          • ExecuteResultAsync
        • Operators
          • Implicit
            • Implicit(TValue to RollbackResult<TValue>)
            • Implicit(ActionResult<TValue> to RollbackResult<TValue>)
      • TransactionAttribute
        • Constructors
          • TransactionAttribute
        • Properties
          • AsyncFlowOption
          • CommitPolicy
          • IsolationLevel
          • ScopeTimeout
        • Methods
          • OnActionExecuted
          • OnActionExecuting
          • OnResultExecuted
      • WebExtensions
        • Methods
          • AddGzipCompression
          • UseCoreIntegrated
          • UseTransaction

    SqlSelectAttribute.SqlSelectAttribute(string selectName) Constructor

    .NET Standard 2.x

    Initializes a new instance of the SqlSelectAttribute class.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

       public SqlSelectAttribute(string selectName)
    

    Parameters

    selectName System.String

    The name of the select list.

    Applies to

    .NET Standard

    2.x

    In This Article
    • Syntax
    • Applies to
    Back to top Generated by Appeon