Class TargetedSelect<MainTableInfo>

Inheritance

object

SqlCommand

PrivateSelect

Select

TargetedSelect<MainTableInfo>

Implements

ICloneable

Inherited Members

Select.RestrictionAnd(Restriction)

Select.RestrictionOr(Restriction)

Select.ReturnFields

Select.OrderBy

Select.GroupBy

Select.JoinRestriction

Select.Restriction

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.IsDistinct

PrivateSelect.ForceRecompile

PrivateSelect.SqlType

SqlCommand.Origin

SqlCommand.AdditionalInfo

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()

Namespace: SuperOffice.Data.SQL

Assembly: SoDataBase.dll

Syntax

public sealed class TargetedSelect<MainTableInfo> : Select, ICloneable where MainTableInfo : TableInfo

Type Parameters

Name	Description
MainTableInfo

Properties

ExplicitConnection

Declaration

public SoConnection ExplicitConnection { get; }

Property Value

Type	Description
SoConnection

Table

Declaration

public MainTableInfo Table { get; }

Property Value

Type	Description
MainTableInfo

Methods

ExecuteScalar<ReturnType>(Func<MainTableInfo, FieldInfo>)

Declaration

public ReturnType ExecuteScalar<ReturnType>(Func<MainTableInfo, FieldInfo> getReturnField)

Parameters

Type	Name	Description
Func<MainTableInfo, FieldInfo>	getReturnField

Returns

Type	Description
ReturnType

Type Parameters

Name	Description
ReturnType

Records()

Declaration

public IEnumerable<TargetedDataRecord<MainTableInfo>> Records()

Returns

Type	Description
IEnumerable<TargetedDataRecord<MainTableInfo>>

Records(params Argument[])

Declaration

public IEnumerable<TargetedDataRecord<MainTableInfo>> Records(params Argument[] returnArguments)

Parameters

Type	Name	Description
Argument[]	returnArguments

Returns

Type	Description
IEnumerable<TargetedDataRecord<MainTableInfo>>

Records(Func<MainTableInfo, Argument[]>)

Declaration

public IEnumerable<TargetedDataRecord<MainTableInfo>> Records(Func<MainTableInfo, Argument[]> getReturnField)

Parameters

Type	Name	Description
Func<MainTableInfo, Argument[]>	getReturnField

Returns

Type	Description
IEnumerable<TargetedDataRecord<MainTableInfo>>

Records(Func<MainTableInfo, Argument>)

Declaration

public IEnumerable<TargetedDataRecord<MainTableInfo>> Records(Func<MainTableInfo, Argument> getReturnField)

Parameters

Type	Name	Description
Func<MainTableInfo, Argument>	getReturnField

Returns

Type	Description
IEnumerable<TargetedDataRecord<MainTableInfo>>

SetExplicitConnection(SoConnection)

Declaration

public TargetedSelect<MainTableInfo> SetExplicitConnection(SoConnection explicitConnection)

Parameters

Type	Name	Description
SoConnection	explicitConnection

Returns

Type	Description
TargetedSelect<MainTableInfo>

SetIgnoreSentry(bool)

Declaration

public TargetedSelect<MainTableInfo> SetIgnoreSentry(bool ignoreSentry)

Parameters

Type	Name	Description
bool	ignoreSentry

Returns

Type	Description
TargetedSelect<MainTableInfo>

SetIsDistinct(bool)

Declaration

public TargetedSelect<MainTableInfo> SetIsDistinct(bool isDistinct)

Parameters

Type	Name	Description
bool	isDistinct

Returns

Type	Description
TargetedSelect<MainTableInfo>

SetOrderBy(Func<MainTableInfo, FieldInfo>)

Declaration

public TargetedSelect<MainTableInfo> SetOrderBy(Func<MainTableInfo, FieldInfo> getOrderBy)

Parameters

Type	Name	Description
Func<MainTableInfo, FieldInfo>	getOrderBy

Returns

Type	Description
TargetedSelect<MainTableInfo>

SetOrderBy(Func<MainTableInfo, OrderBy[]>)

Declaration

public TargetedSelect<MainTableInfo> SetOrderBy(Func<MainTableInfo, OrderBy[]> getOrderBys)

Parameters

Type	Name	Description
Func<MainTableInfo, OrderBy[]>	getOrderBys

Returns

Type	Description
TargetedSelect<MainTableInfo>

SetOrderBy(Func<MainTableInfo, OrderBy>)

Declaration

public TargetedSelect<MainTableInfo> SetOrderBy(Func<MainTableInfo, OrderBy> getOrderBy)

Parameters

Type	Name	Description
Func<MainTableInfo, OrderBy>	getOrderBy

Returns

Type	Description
TargetedSelect<MainTableInfo>

Implements

ICloneable

Extension Methods

QueryExectionExtensions.ExecuteNonQuery(SqlCommand)

QueryExectionExtensions.ExecuteReader(SqlCommand, bool)

QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)