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)