Table of Contents

Class SelectQuery

Namespace
The.SQL.QIR.Queries
Assembly
Instagile.dll
[MessagePackObject(false)]
public sealed record SelectQuery : Query, IEquatable<Query>, IEquatable<SelectQuery>
Inheritance
SelectQuery
Implements
Inherited Members

Constructors

SelectQuery(bool, Projection, Table, TableHint, RecordList<Join>, Condition?, RecordList<Value>)

public SelectQuery(bool Distinct, Projection Columns, Table From, TableHint TableHints, RecordList<Join> Join, Condition? Where, RecordList<Value> GroupBy)

Parameters

Distinct bool
Columns Projection
From Table
TableHints TableHint
Join RecordList<Join>
Where Condition
GroupBy RecordList<Value>

SelectQuery(Table, Condition, params Value[])

public SelectQuery(Table from, Condition where, params Value[] selectList)

Parameters

from Table
where Condition
selectList Value[]

SelectQuery(Table, params Value[])

public SelectQuery(Table source, params Value[] selectList)

Parameters

source Table
selectList Value[]

Properties

Columns

[Key(2)]
public Projection Columns { get; init; }

Property Value

Projection

Distinct

[Key(1)]
public bool Distinct { get; init; }

Property Value

bool

From

[Key(3)]
public Table From { get; init; }

Property Value

Table

GroupBy

[Key(7)]
public RecordList<Value> GroupBy { get; init; }

Property Value

RecordList<Value>

IsLiteral

[IgnoreMember]
public override bool IsLiteral { get; }

Property Value

bool

Join

[Key(5)]
public RecordList<Join> Join { get; init; }

Property Value

RecordList<Join>

TableHints

[Key(4)]
public TableHint TableHints { get; init; }

Property Value

TableHint

Where

[Key(6)]
public Condition? Where { get; init; }

Property Value

Condition

Methods

IsUnisolated()

public override bool IsUnisolated()

Returns

bool

ToLines()

public override IEnumerable<string> ToLines()

Returns

IEnumerable<string>

ToRefString()

public override string ToRefString()

Returns

string

ToString()

Returns a string that represents the current object.

public override string ToString()

Returns

string

A string that represents the current object.

WithSource(Table, Table)

public override Query WithSource(Table oldSource, Table newSource)

Parameters

oldSource Table
newSource Table

Returns

Query