Show / Hide Table of Contents

Class ListSelect

The ListSelect class is the base-class for all simple lists.

Inheritance
Object
SqlCommand
PrivateSelect
ListSelect
ContactList.ContactListQuery
DocumentList.DocumentListQuery
PersonList.PersonListQuery
ProjectEventList.ProjectEventListQuery
ProjectList.ProjectListQuery
ProjectMemberList.ProjectMemberListQuery
SaleList.SaleListQuery
UserList.UserListQuery
Implements
ICloneable
Inherited Members
PrivateSelect._isDistinct
PrivateSelect.GetTableInfos()
PrivateSelect.GetRelations(TableInfo)
PrivateSelect.GetRelations(TableInfo, SoTable)
PrivateSelect.IsTableOuterJoined(TableInfo)
PrivateSelect.GetTablesInOrderBy()
PrivateSelect.GetTablesLeadingToTable(TableInfo)
PrivateSelect.ValidateJoin()
PrivateSelect.Clone()
PrivateSelect.CloneSelect()
PrivateSelect.ToString()
PrivateSelect.GetCachingHash()
PrivateSelect.GetRestrictionTables()
PrivateSelect.CreateOrderBy()
PrivateSelect.IsDistinct
PrivateSelect.ForceRecompile
PrivateSelect.ForceJoinOrder
PrivateSelect.SqlType
SqlCommand.Origin
SqlCommand.AddIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.AddIgnoreAutoSentryTableInfo(IEnumerable<TableInfo>)
SqlCommand.RemoveIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.ClearIgnoreAutoSentryTableInfos()
SqlCommand.IsAutoSentryIgnoredOnTableInfo(TableInfo)
SqlCommand.GetPrivateSaves()
SqlCommand.GetInserts()
SqlCommand.GetUpdates()
SqlCommand.GetDeletes()
SqlCommand.GetSelect()
SqlCommand.AutoSentryIgnoredTables
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
public abstract class ListSelect : PrivateSelect, ICloneable

Constructors

ListSelect()

Default constructor

Declaration
protected ListSelect()

Fields

_fields

Declaration
protected ReturnFieldsCollection _fields
Field Value
Type Description
ReturnFieldsCollection

_groupBy

Declaration
protected GroupBy _groupBy
Field Value
Type Description
GroupBy

_joinRestriction

Declaration
protected JoinRestriction _joinRestriction
Field Value
Type Description
JoinRestriction

_orderBy

Declaration
protected OrderBy _orderBy
Field Value
Type Description
OrderBy

_restriction

Declaration
protected Restriction _restriction
Field Value
Type Description
Restriction

Properties

InnerGroupBy

Implementation of the Group by clause.

Declaration
protected override GroupBy InnerGroupBy { get; }
Property Value
Type Description
GroupBy
Overrides
PrivateSelect.InnerGroupBy

InnerJoinRestriction

Implementation of InnerJoinRestriction enabling the
Dialect to get the JoinRestriction object through the PrivateSelect class.

Declaration
protected override JoinRestriction InnerJoinRestriction { get; }
Property Value
Type Description
JoinRestriction
Overrides
PrivateSelect.InnerJoinRestriction

InnerOrderBy

Implementation of the OrderBy clause.

Declaration
protected override OrderBy InnerOrderBy { get; }
Property Value
Type Description
OrderBy
Overrides
PrivateSelect.InnerOrderBy

InnerRestriction

Implementation of InnerRestriction enabling the
Dialect to get the Restriction object through the PrivateSelect class.

Declaration
protected override Restriction InnerRestriction { get; }
Property Value
Type Description
Restriction
Overrides
PrivateSelect.InnerRestriction

InnerReturnFields

Implementation of InnerReturnFields enabling the Dialect to get the ReturnFieldsCollection object through the PrivateSelect class

Declaration
protected override ReturnFieldsCollection InnerReturnFields { get; }
Property Value
Type Description
ReturnFieldsCollection
Overrides
PrivateSelect.InnerReturnFields

Methods

CreateListReader(SoConnection, PrivateSelect, Sentry[])

CreateListReader will generate the query and populate the SoDataReader.

Declaration
protected static SoDataReader CreateListReader(SoConnection con, PrivateSelect select, params Sentry[] sentries)
Parameters
Type Name Description
SoConnection con

Connection used to create the reader

PrivateSelect select

The select object-structure which contains the query-structure.

Sentry[] sentries

Array of Sentry objects to be used

Returns
Type Description
SoDataReader

A populated data-reader.

Examples

Remember to close the connection and the reader:

using (SoConnection con = ConnectionFactory.GetConnection())
{
    using (SoDataReader reader = CreateListReader(con, this, sentries))
    {
        list.OnLoad(reader);
    }
}								

CreateListReader(SoConnection, PrivateSelect, Int32, Sentry[])

Declaration
protected static SoDataReader CreateListReader(SoConnection con, PrivateSelect select, int maxRows, params Sentry[] sentries)
Parameters
Type Name Description
SoConnection con
PrivateSelect select
Int32 maxRows
Sentry[] sentries
Returns
Type Description
SoDataReader

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
QueryExectionExtensions.ExecuteReader(SqlCommand, Boolean)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
QueryExectionExtensions.ExecuteNonQuery(SqlCommand)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top