SelectFromImpl<T> Class

Namespace:: Maroontress.SqlBind.Impl

Assembly:: SqlBind.dll

The default implementation of SelectFrom<T>.

public sealed class SelectFromImpl<T> : AbstractSelectSorter<T>, SelectFrom<T>
    where T : notnull

Type Parameters

T: notnull

The type of the class representing any row of the result of the query.

Inheritance: object

AbstractSelectSorter<T>
SelectFromImpl<T>

Implements: SelectFrom<T> SelectSorter<T> SelectTerminator<T>

Constructors

SelectFromImpl(MetadataBank, Siphon, string)

The default implementation of SelectFrom<T>.

Properties

Text	Gets the SQL query text. (Inherited from AbstractSelectSorter<T>)

Methods

InnerJoin<U>(string, string)	Description copied from interface: SelectFrom Gets a new SelectFrom<T> object, which represents the combination of `this` (`SELECT` ... `From` ...) and the `INNER JOIN` ... `ON` ... clause with the table that `U` represents.
Where(string, IReadOnlyDictionary<string, object>)	Description copied from interface: SelectFrom Gets a new Where<T> object, which represents the combination of `this` (`SELECT` ... `From` ...) and the `WHERE` ... clause.
OrderBy(string[])	Description copied from interface: SelectSorter Executes the query and gets the result in the order sorted by the specified columns. (Inherited from AbstractSelectSorter<T>)
Execute()	Description copied from interface: SelectTerminator Executes the query and gets the result. (Inherited from AbstractSelectSorter<T>)
Limit(int)	Description copied from interface: SelectTerminator Executes the query and limits the number of rows that the query returns. (Inherited from AbstractSelectSorter<T>)
LimitOffset(int, int)	Description copied from interface: SelectTerminator Executes the query and limits the number of rows that the query returns and specifies the starting offset. (Inherited from AbstractSelectSorter<T>)
Equals(object)	(Inherited from object)
GetHashCode()	(Inherited from object)
GetType()	(Inherited from object)
MemberwiseClone()	(Inherited from object)
ToString()	(Inherited from object)

Constructors Detail

SelectFromImpl(MetadataBank, Siphon, string)

The default implementation of SelectFrom<T>.

public SelectFromImpl(MetadataBank bank, Siphon siphon, string text)

Parameters

bank: MetadataBank

The Bank object.

siphon: Siphon

The Siphon object.

text: string

The prefix statement.

Methods Detail

InnerJoin<U>(string, string)

Description copied from interface: SelectFrom

Gets a new SelectFrom<T> object, which represents the combination of this (SELECT ... From ...) and the INNER JOIN ... ON ... clause with the table that U represents.

public SelectFrom<T> InnerJoin<U>(string alias, string constraint)

Type Parameters

U: notnull

Parameters

alias: string

constraint: string

Returns

SelectFrom<T>

Description copied from interface: SelectFrom

The new SelectFrom<T> object.

Implements

SelectFrom<T>.InnerJoin<U>(string, string)

Remarks

Description copied from interface: SelectFrom

The object that this method returns represents SELECT ... FROM ... INNER JOIN "the table name of U" alias ON constraint.

Where(string, IReadOnlyDictionary<string, object>)

Description copied from interface: SelectFrom

Gets a new Where<T> object, which represents the combination of this (SELECT ... From ...) and the WHERE ... clause.

public Where<T> Where(string condition, IReadOnlyDictionary<string, object> parameters)

Parameters

condition: string

parameters: IReadOnlyDictionary<string, object>

Returns

Where<T>

Description copied from interface: SelectFrom

The new Where<T> object.

Implements

SelectFrom<T>.Where(string, IReadOnlyDictionary<string, object>)

Remarks

Description copied from interface: SelectFrom

The object that this method returns represents SELECT ... FROM ... WHERE condition.