SelectFrom<T> Interface

Namespace:: Maroontress.SqlBind

Assembly:: SqlBind.dll

Represents the SELECT statement without a WHERE clause. It can end with a INNER JOIN clause.

public interface SelectFrom<T> : SelectSorter<T>
    where T : notnull

Type Parameters

T: notnull

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

Implements: SelectSorter<T> SelectTerminator<T>

Methods

InnerJoin<U>(string, string)	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>)	Gets a new Where<T> object, which represents the combination of `this` (`SELECT` ... `From` ...) and the `WHERE` ... clause.

Methods Detail

InnerJoin<U>(string, string)

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.

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

Type Parameters

U: notnull

The type of the class qualified with the TableAttribute.

Parameters

alias: string

The alias name of the table that U represents.

constraint: string

The expression following ON.

Returns

SelectFrom<T>

The new SelectFrom<T> object.

Remarks

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

Where(string, IReadOnlyDictionary<string, object>)

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

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

Parameters

condition: string

The condition of the WHERE clause.

parameters: IReadOnlyDictionary<string, object>

Immutable key-value pairs. The condition must contain all the keys. Each value must be of the appropriate type.

Returns

Where<T>

The new Where<T> object.

Remarks

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