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

CountAsync(CancellationToken)

Declaration

public Task<int> CountAsync(CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
CancellationToken	cancellationToken

Returns

Type	Description
Task<int>

ExecuteScalarAsync<ReturnType>(Func<MainTableInfo, FieldInfo>, CancellationToken)

Declaration

public Task<ReturnType> ExecuteScalarAsync<ReturnType>(Func<MainTableInfo, FieldInfo> getReturnField, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
Func<MainTableInfo, FieldInfo>	getReturnField
CancellationToken	cancellationToken

Returns

Type	Description
Task<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>>

RecordsAsync(params Argument[])

Declaration

public IAsyncEnumerable<TargetedDataRecord<MainTableInfo>> RecordsAsync(params Argument[] returnArguments)

Parameters

Type	Name	Description
Argument[]	returnArguments

Returns

Type	Description
IAsyncEnumerable<TargetedDataRecord<MainTableInfo>>

RecordsAsync(Func<MainTableInfo, Argument[]>, CancellationToken)

Declaration

public IAsyncEnumerable<TargetedDataRecord<MainTableInfo>> RecordsAsync(Func<MainTableInfo, Argument[]> getReturnField, CancellationToken cancellationToken = default)

Parameters

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

Returns

Type	Description
IAsyncEnumerable<TargetedDataRecord<MainTableInfo>>

RecordsAsync(Func<MainTableInfo, Argument>, CancellationToken)

Declaration

[CreateSyncVersion(OmitNullableDirective = true)]
public IAsyncEnumerable<TargetedDataRecord<MainTableInfo>> RecordsAsync(Func<MainTableInfo, Argument> getReturnField, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
Func<MainTableInfo, Argument>	getReturnField
CancellationToken	cancellationToken

Returns

Type	Description
IAsyncEnumerable<TargetedDataRecord<MainTableInfo>>

RecordsAsync(CancellationToken)

Declaration

[CreateSyncVersion(OmitNullableDirective = true)]
public IAsyncEnumerable<TargetedDataRecord<MainTableInfo>> RecordsAsync(CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
CancellationToken	cancellationToken

Returns

Type	Description
IAsyncEnumerable<TargetedDataRecord<MainTableInfo>>

RecordsAsync(CancellationToken, params Argument[])

Declaration

[CreateSyncVersion(OmitNullableDirective = true)]
public IAsyncEnumerable<TargetedDataRecord<MainTableInfo>> RecordsAsync(CancellationToken cancellationToken, params Argument[] returnArguments)

Parameters

Type	Name	Description
CancellationToken	cancellationToken
Argument[]	returnArguments

Returns

Type	Description
IAsyncEnumerable<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>

SetOriginText(string)

Set a comment text that is included in the generated query. It can help a lot when tracing slow/misbehaving sql

Declaration

public TargetedSelect<MainTableInfo> SetOriginText(string origin)

Parameters

Type	Name	Description
string	origin

Returns

Type	Description
TargetedSelect<MainTableInfo>

Implements

ICloneable

Extension Methods

QueryExectionExtensions.ExecuteNonQuery(SqlCommand)

QueryExectionExtensions.ExecuteNonQueryAsync(SqlCommand, CancellationToken)

QueryExectionExtensions.ExecuteReader(SqlCommand, bool)

QueryExectionExtensions.ExecuteReaderAsync(SqlCommand, bool, CancellationToken)

QueryExectionExtensions.ExecuteScalarAsync<T>(SqlCommand, bool, CancellationToken)

QueryExectionExtensions.ExecuteScalarAsync<T>(SqlCommand, CancellationToken)

QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)