typed_sql library
API for defining database schema and writing queries against generated code.
This library should be imported in the model.dart
file where you define
you database schema, which is then augmented with generated code in a
model.g.dart
file. For convenience, you may also wish to export this
library from your model.dart
file.
See topic on schema defintion for how to get started.
Classes
-
Aggregation<
T extends Record, S extends Record> Aggregate functions - AutoIncrement Schema definition
- Annotation for a field that should be auto-incremented (by default).
-
CustomDataType<
T extends Object?> Schema definition Custom data types - Interface to be implemented by custom types that can be stored in a Row for automatic (de)-serialization.
-
Database<
T extends Schema> Transactions - DatabaseAdapter Testing
- Interface that a database adapter must implement.
-
DefaultValue<
T> Schema definition - Annotation for a field that has a default value, specified by value.
-
Delete<
T extends Row> -
A
DELETE
statement deleting multiple rows. -
DeleteSingle<
T extends Row> -
A
DELETE
statement deleting at-most one row. -
Expr<
T extends Object?> Inserting rows Writing queries Update and delete -
A representation of an SQL expression with type
T
. -
ExpressionIsNotDistinctFrom<
T extends Object> -
SQL Expression using
IS NOT DISTINCT FROM
. - ForeignKey Schema definition Foreign keys
- Annotation for declaring a composite foreign key.
-
Group<
S extends Record, T extends Record> Aggregate functions -
InnerJoin<
T extends Record, S extends Record> Joins -
InsertSingle<
T extends Row> -
A
INSERT
statement to insert a single row. -
LeftJoin<
T extends Record, S extends Record> Joins -
OrderedQuery<
T extends Record> Writing queries -
A Query which has an order imposed by
.orderBy
. -
OrderedQueryRange<
T extends Record> Writing queries -
A Query which has an order imposed by
.orderBy
and is limited to a range by.limit
or.offset
. -
OrderedSubQuery<
T extends Record> Writing queries -
A SubQuery which has an order imposed by
.orderBy
. -
OrderedSubQueryRange<
T extends Record> Writing queries -
A SubQuery which has an order imposed by
.orderBy
and is limited to a range by.limit
or.offset
. - PrimaryKey Schema definition
- Annotation for a table specifying its primary key.
-
ProjectedOrderedQuery<
T extends Record> Writing queries -
A Query which has an order imposed by
.orderBy
and is projected to a new set of columns using.select
(or.distinct
). -
ProjectedOrderedQueryRange<
T extends Record> Writing queries -
A Query which has an order imposed by
.orderBy
, is projected to a new set of columns using.select
(or.distinct
), and is limited to a range by.limit
or.offset
. -
ProjectedOrderedSubQuery<
T extends Record> Writing queries -
A SubQuery which has an order imposed by
.orderBy
and is projected to a new set of columns using.select
(or.distinct
). -
ProjectedOrderedSubQueryRange<
T extends Record> Writing queries -
A SubQuery which has an order imposed by
.orderBy
, is projected to a new set of columns using.select
(or.distinct
), and is limited to a range by.limit
or.offset
. -
Query<
T extends Record> Writing queries - A Query on the database from which results can be fetched.
-
QuerySingle<
T extends Record> Writing queries - A Query which can return at-most a single row.
- References Schema definition Foreign keys
- Annotation for fields that references fields from another table.
-
Return<
T extends Record> - An SQL statement that returns zero or more rows.
-
ReturnOne<
T extends Record> - An SQL statement that returns exactly one row.
-
ReturnSingle<
T extends Record> - An SQL statement that returns at-most one row.
-
RightJoin<
T extends Record, S extends Record> Joins - Row Schema definition
- Marker class which all row classes must extend.
- RowReader
- Interface for reading rows from a database.
- Schema Schema definition Migrations
- Marker class which all schema definitions must extend.
- SqlDialect
-
Interface for implementation of custom SQL dialects for
package:typed_sql
. -
SubQuery<
T extends Record> Writing queries - A Query which can only be used as a subquery.
-
Table<
T extends Row> Inserting rows Writing queries Update and delete -
A table of rows of type
T
. - Unique Schema definition
- Annotation for a unique field.
-
Update<
T extends Row> -
A
UPDATE
statement to update multiple rows. -
UpdateSet<
T extends Row> - A set of mutations to be applied when updating rows.
-
UpdateSingle<
T extends Row> -
A
UPDATE
statement to update at-most one row.
Enums
Extensions
-
Aggregate1Project1
on Aggregation<
(Expr< A> ), (Expr<B> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate1Project2
on Aggregation<
(Expr< A> ), (Expr<B> , Expr<C> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate1Project3
on Aggregation<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate1Project4
on Aggregation<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate1Project5
on Aggregation<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate1Project6
on Aggregation<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate1Project7
on Aggregation<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate2Project1
on Aggregation<
(Expr< A> , Expr<B> ), (Expr<C> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate2Project2
on Aggregation<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate2Project3
on Aggregation<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate2Project4
on Aggregation<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate2Project5
on Aggregation<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate2Project6
on Aggregation<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate3Project1
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate3Project2
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate3Project3
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate3Project4
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate3Project5
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate4Project1
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate4Project2
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate4Project3
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate4Project4
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate5Project1
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate5Project2
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate5Project3
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> , Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate6Project1
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate6Project2
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> , Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
-
Aggregate7Project1
on Aggregation<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), (Expr<H> )> - Extension methods for specifying aggregate functions over rows in a group.
- BoolExt on T
- Extension methods for wrapping a bool as an expression.
-
CustomTypeExt
on Expr<
CustomDataType< S> > - Extension methods for accessing the encoded value of a custom data type expression.
-
CustomTypeNullableExt
on Expr<
CustomDataType< S> ?> - Extension methods for accessing the encoded value of a custom data type expression.
- DateTimeExt on T
- Extension methods for wrapping a DateTime as an expression.
- DoubleExt on T
- Extension methods for wrapping a double as an expression.
-
ExpressionBool
on Expr<
bool> - Extension methods for bool expressions.
-
ExpressionDateTime
on Expr<
DateTime> - Extension methods for DateTime expressions.
-
ExpressionDouble
on Expr<
double> - Extension methods for double expressions.
-
ExpressionInt
on Expr<
int> - Extension methods for int expressions.
-
ExpressionNull
on Expr<
Null> -
Extension methods for casting
NULL
to other types. -
ExpressionNullable
on Expr<
T?> - Extension methods for casting a nullable Expr to a non-nullable Expr.
-
ExpressionNullableBool
on Expr<
bool?> - Extension methods for nullable bool expressions.
-
ExpressionNullableDateTime
on Expr<
DateTime?> - Extension methods for nullable DateTime expressions.
-
ExpressionNullableNum
on Expr<
T?> - Extension methods for nullable int and double expressions.
-
ExpressionNullableString
on Expr<
String?> - Extension methods for nullable String expressions.
-
ExpressionNum
on Expr<
T> - Extension methods for int and double expressions.
-
ExpressionString
on Expr<
String> - Extension methods for String expressions.
-
Group1By1
on Group<
(Expr< A> ), (Expr<B> )> -
Extension methods for completing a
GROUP BY
. -
Group1By2
on Group<
(Expr< A> , Expr<B> ), (Expr<C> )> -
Extension methods for completing a
GROUP BY
. -
Group1By3
on Group<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> )> -
Extension methods for completing a
GROUP BY
. -
Group1By4
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> )> -
Extension methods for completing a
GROUP BY
. -
Group1By5
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> )> -
Extension methods for completing a
GROUP BY
. -
Group1By6
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> )> -
Extension methods for completing a
GROUP BY
. -
Group1By7
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), (Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
Group2By1
on Group<
(Expr< A> ), (Expr<B> , Expr<C> )> -
Extension methods for completing a
GROUP BY
. -
Group2By2
on Group<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> )> -
Extension methods for completing a
GROUP BY
. -
Group2By3
on Group<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> )> -
Extension methods for completing a
GROUP BY
. -
Group2By4
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> )> -
Extension methods for completing a
GROUP BY
. -
Group2By5
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> )> -
Extension methods for completing a
GROUP BY
. -
Group2By6
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> , Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
Group3By1
on Group<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> )> -
Extension methods for completing a
GROUP BY
. -
Group3By2
on Group<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing a
GROUP BY
. -
Group3By3
on Group<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing a
GROUP BY
. -
Group3By4
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing a
GROUP BY
. -
Group3By5
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
Group4By1
on Group<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing a
GROUP BY
. -
Group4By2
on Group<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing a
GROUP BY
. -
Group4By3
on Group<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing a
GROUP BY
. -
Group4By4
on Group<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
Group5By1
on Group<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing a
GROUP BY
. -
Group5By2
on Group<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing a
GROUP BY
. -
Group5By3
on Group<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
Group6By1
on Group<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing a
GROUP BY
. -
Group6By2
on Group<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
Group7By1
on Group<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing a
GROUP BY
. -
InnerJoin1On1
on InnerJoin<
(Expr< A> ), (Expr<B> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin1On2
on InnerJoin<
(Expr< A> ), (Expr<B> , Expr<C> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin1On3
on InnerJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin1On4
on InnerJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin1On5
on InnerJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin1On6
on InnerJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin1On7
on InnerJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin2On1
on InnerJoin<
(Expr< A> , Expr<B> ), (Expr<C> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin2On2
on InnerJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin2On3
on InnerJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin2On4
on InnerJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin2On5
on InnerJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin2On6
on InnerJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin3On1
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin3On2
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin3On3
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin3On4
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin3On5
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin4On1
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin4On2
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin4On3
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin4On4
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin5On1
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin5On2
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin5On3
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin6On1
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin6On2
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> , Expr<H> )> -
Extension methods for completing an
INNER JOIN
. -
InnerJoin7On1
on InnerJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), (Expr<H> )> -
Extension methods for completing an
INNER JOIN
. - IntExt on T
- Extension methods for wrapping an int as an expression.
-
LeftJoin1On1
on LeftJoin<
(Expr< A> ), (Expr<B> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin1On2
on LeftJoin<
(Expr< A> ), (Expr<B> , Expr<C> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin1On3
on LeftJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin1On4
on LeftJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin1On5
on LeftJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin1On6
on LeftJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin1On7
on LeftJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin2On1
on LeftJoin<
(Expr< A> , Expr<B> ), (Expr<C> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin2On2
on LeftJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin2On3
on LeftJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin2On4
on LeftJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin2On5
on LeftJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin2On6
on LeftJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin3On1
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin3On2
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin3On3
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin3On4
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin3On5
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin4On1
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin4On2
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin4On3
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin4On4
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin5On1
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin5On2
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin5On3
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin6On1
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin6On2
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> , Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
LeftJoin7On1
on LeftJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), (Expr<H> )> -
Extension methods for completing an
LEFT JOIN
. -
OrderedQuery1
on OrderedQuery<
(Expr< A> )> - Extension methods for a query returning zero or more rows with 1 expression.
-
OrderedQuery2
on OrderedQuery<
(Expr< A> , Expr<B> )> - Extension methods for a query returning zero or more rows with 2 expressions.
-
OrderedQuery3
on OrderedQuery<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a query returning zero or more rows with 3 expressions.
-
OrderedQuery4
on OrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a query returning zero or more rows with 4 expressions.
-
OrderedQuery5
on OrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a query returning zero or more rows with 5 expressions.
-
OrderedQuery6
on OrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a query returning zero or more rows with 6 expressions.
-
OrderedQuery7
on OrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a query returning zero or more rows with 7 expressions.
-
OrderedQuery8
on OrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a query returning zero or more rows with 8 expressions.
-
OrderedQueryExt
on OrderedQuery<
T> - Extension methods for all ordered queries.
-
OrderedQueryRange1
on OrderedQueryRange<
(Expr< A> )> - Extension methods for a query returning zero or more rows with 1 expression.
-
OrderedQueryRange2
on OrderedQueryRange<
(Expr< A> , Expr<B> )> - Extension methods for a query returning zero or more rows with 2 expressions.
-
OrderedQueryRange3
on OrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a query returning zero or more rows with 3 expressions.
-
OrderedQueryRange4
on OrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a query returning zero or more rows with 4 expressions.
-
OrderedQueryRange5
on OrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a query returning zero or more rows with 5 expressions.
-
OrderedQueryRange6
on OrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a query returning zero or more rows with 6 expressions.
-
OrderedQueryRange7
on OrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a query returning zero or more rows with 7 expressions.
-
OrderedQueryRange8
on OrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a query returning zero or more rows with 8 expressions.
-
OrderedQueryRangeExt
on OrderedQueryRange<
T> - Extension methods for all ordered queries.
-
OrderedSubQuery1
on OrderedSubQuery<
(Expr< A> )> - Extension methods for a ordered subquery of zero or more rows with 1 expression.
-
OrderedSubQuery1Ext
on OrderedSubQuery<
(Expr< T> )> - Extension methods for subqueries projected to a single expression.
-
OrderedSubQuery2
on OrderedSubQuery<
(Expr< A> , Expr<B> )> - Extension methods for a ordered subquery of zero or more rows with 2 expressions.
-
OrderedSubQuery3
on OrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a ordered subquery of zero or more rows with 3 expressions.
-
OrderedSubQuery4
on OrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a ordered subquery of zero or more rows with 4 expressions.
-
OrderedSubQuery5
on OrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a ordered subquery of zero or more rows with 5 expressions.
-
OrderedSubQuery6
on OrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a ordered subquery of zero or more rows with 6 expressions.
-
OrderedSubQuery7
on OrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a ordered subquery of zero or more rows with 7 expressions.
-
OrderedSubQuery8
on OrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a ordered subquery of zero or more rows with 8 expressions.
-
OrderedSubQueryExt
on OrderedSubQuery<
T> - Extension methods for all ordered subqueries.
-
OrderedSubQueryRange1
on OrderedSubQueryRange<
(Expr< A> )> - Extension methods for a ordered subquery of zero or more rows with 1 expression.
-
OrderedSubQueryRange1Ext
on OrderedSubQueryRange<
(Expr< T> )> - Extension methods for subqueries projected to a single expression.
-
OrderedSubQueryRange2
on OrderedSubQueryRange<
(Expr< A> , Expr<B> )> - Extension methods for a ordered subquery of zero or more rows with 2 expressions.
-
OrderedSubQueryRange3
on OrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a ordered subquery of zero or more rows with 3 expressions.
-
OrderedSubQueryRange4
on OrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a ordered subquery of zero or more rows with 4 expressions.
-
OrderedSubQueryRange5
on OrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a ordered subquery of zero or more rows with 5 expressions.
-
OrderedSubQueryRange6
on OrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a ordered subquery of zero or more rows with 6 expressions.
-
OrderedSubQueryRange7
on OrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a ordered subquery of zero or more rows with 7 expressions.
-
OrderedSubQueryRange8
on OrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a ordered subquery of zero or more rows with 8 expressions.
-
OrderedSubQueryRangeExt
on OrderedSubQueryRange<
T> - Extension methods for all ordered subqueries.
-
ProjectedOrderedQuery1
on ProjectedOrderedQuery<
(Expr< A> )> - Extension methods for a query returning zero or more rows with 1 expression.
-
ProjectedOrderedQuery2
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> )> - Extension methods for a query returning zero or more rows with 2 expressions.
-
ProjectedOrderedQuery3
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a query returning zero or more rows with 3 expressions.
-
ProjectedOrderedQuery4
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a query returning zero or more rows with 4 expressions.
-
ProjectedOrderedQuery5
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a query returning zero or more rows with 5 expressions.
-
ProjectedOrderedQuery6
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a query returning zero or more rows with 6 expressions.
-
ProjectedOrderedQuery7
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a query returning zero or more rows with 7 expressions.
-
ProjectedOrderedQuery8
on ProjectedOrderedQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a query returning zero or more rows with 8 expressions.
-
ProjectedOrderedQueryExt
on ProjectedOrderedQuery<
T> - Extension methods for all ordered queries.
-
ProjectedOrderedQueryRange1
on ProjectedOrderedQueryRange<
(Expr< A> )> - Extension methods for a query returning zero or more rows with 1 expression.
-
ProjectedOrderedQueryRange2
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> )> - Extension methods for a query returning zero or more rows with 2 expressions.
-
ProjectedOrderedQueryRange3
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a query returning zero or more rows with 3 expressions.
-
ProjectedOrderedQueryRange4
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a query returning zero or more rows with 4 expressions.
-
ProjectedOrderedQueryRange5
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a query returning zero or more rows with 5 expressions.
-
ProjectedOrderedQueryRange6
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a query returning zero or more rows with 6 expressions.
-
ProjectedOrderedQueryRange7
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a query returning zero or more rows with 7 expressions.
-
ProjectedOrderedQueryRange8
on ProjectedOrderedQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a query returning zero or more rows with 8 expressions.
-
ProjectedOrderedQueryRangeExt
on ProjectedOrderedQueryRange<
T> - Extension methods for all ordered queries.
-
ProjectedOrderedSubQuery1
on ProjectedOrderedSubQuery<
(Expr< A> )> - Extension methods for a ordered subquery of zero or more rows with 1 expression.
-
ProjectedOrderedSubQuery1Ext
on ProjectedOrderedSubQuery<
(Expr< T> )> - Extension methods for subqueries projected to a single expression.
-
ProjectedOrderedSubQuery2
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> )> - Extension methods for a ordered subquery of zero or more rows with 2 expressions.
-
ProjectedOrderedSubQuery3
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a ordered subquery of zero or more rows with 3 expressions.
-
ProjectedOrderedSubQuery4
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a ordered subquery of zero or more rows with 4 expressions.
-
ProjectedOrderedSubQuery5
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a ordered subquery of zero or more rows with 5 expressions.
-
ProjectedOrderedSubQuery6
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a ordered subquery of zero or more rows with 6 expressions.
-
ProjectedOrderedSubQuery7
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a ordered subquery of zero or more rows with 7 expressions.
-
ProjectedOrderedSubQuery8
on ProjectedOrderedSubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a ordered subquery of zero or more rows with 8 expressions.
-
ProjectedOrderedSubQueryExt
on ProjectedOrderedSubQuery<
T> - Extension methods for all ordered subqueries.
-
ProjectedOrderedSubQueryRange1
on ProjectedOrderedSubQueryRange<
(Expr< A> )> - Extension methods for a ordered subquery of zero or more rows with 1 expression.
-
ProjectedOrderedSubQueryRange1Ext
on ProjectedOrderedSubQueryRange<
(Expr< T> )> - Extension methods for subqueries projected to a single expression.
-
ProjectedOrderedSubQueryRange2
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> )> - Extension methods for a ordered subquery of zero or more rows with 2 expressions.
-
ProjectedOrderedSubQueryRange3
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a ordered subquery of zero or more rows with 3 expressions.
-
ProjectedOrderedSubQueryRange4
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a ordered subquery of zero or more rows with 4 expressions.
-
ProjectedOrderedSubQueryRange5
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a ordered subquery of zero or more rows with 5 expressions.
-
ProjectedOrderedSubQueryRange6
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a ordered subquery of zero or more rows with 6 expressions.
-
ProjectedOrderedSubQueryRange7
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a ordered subquery of zero or more rows with 7 expressions.
-
ProjectedOrderedSubQueryRange8
on ProjectedOrderedSubQueryRange<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a ordered subquery of zero or more rows with 8 expressions.
-
ProjectedOrderedSubQueryRangeExt
on ProjectedOrderedSubQueryRange<
T> - Extension methods for all ordered subqueries.
-
Query1
on Query<
(Expr< A> )> - Extension methods for a query returning zero or more rows with 1 expression.
-
Query2
on Query<
(Expr< A> , Expr<B> )> - Extension methods for a query returning zero or more rows with 2 expressions.
-
Query3
on Query<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a query returning zero or more rows with 3 expressions.
-
Query4
on Query<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a query returning zero or more rows with 4 expressions.
-
Query5
on Query<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a query returning zero or more rows with 5 expressions.
-
Query6
on Query<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a query returning zero or more rows with 6 expressions.
-
Query7
on Query<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a query returning zero or more rows with 7 expressions.
-
Query8
on Query<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a query returning zero or more rows with 8 expressions.
-
QueryDateTime
on Query<
(Expr< DateTime?> )> - Extension methods for queries projected to a DateTime expression.
-
QueryExt
on Query<
T> - Extension methods for all queries.
-
QueryInteger
on Query<
(Expr< int?> )> - Extension methods for queries projected to an int expression.
-
QueryReal
on Query<
(Expr< double?> )> - Extension methods for queries projected to a double expression.
-
QuerySingle1
on QuerySingle<
(Expr< A> )> - Extensions for a query returning at-most one row with 1 expression.
-
QuerySingle1AsExpr
on QuerySingle<
(Expr< T> )> - Extension methods for queries projected to a single expression.
-
QuerySingle2
on QuerySingle<
(Expr< A> , Expr<B> )> - Extensions for a query returning at-most one row with 2 expressions.
-
QuerySingle3
on QuerySingle<
(Expr< A> , Expr<B> , Expr<C> )> - Extensions for a query returning at-most one row with 3 expressions.
-
QuerySingle4
on QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extensions for a query returning at-most one row with 4 expressions.
-
QuerySingle5
on QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extensions for a query returning at-most one row with 5 expressions.
-
QuerySingle6
on QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extensions for a query returning at-most one row with 6 expressions.
-
QuerySingle7
on QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extensions for a query returning at-most one row with 7 expressions.
-
QuerySingle8
on QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extensions for a query returning at-most one row with 8 expressions.
-
QueryString
on Query<
(Expr< String?> )> - Extension methods for queries projected to a String expression.
-
QuerySubExt
on SubQuery<
T> - Extension methods for all subqueries.
-
Return1
on Return<
(Expr< A> )> - Extension methods for a statement returning zero or more rows with 1 expression.
-
Return2
on Return<
(Expr< A> , Expr<B> )> - Extension methods for a statement returning zero or more rows with 2 expressions.
-
Return3
on Return<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a statement returning zero or more rows with 3 expressions.
-
Return4
on Return<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a statement returning zero or more rows with 4 expressions.
-
Return5
on Return<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a statement returning zero or more rows with 5 expressions.
-
Return6
on Return<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a statement returning zero or more rows with 6 expressions.
-
Return7
on Return<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a statement returning zero or more rows with 7 expressions.
-
Return8
on Return<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a statement returning zero or more rows with 8 expressions.
-
ReturnOne1
on ReturnOne<
(Expr< A> )> - Extension methods for a statement returning exactly one row with 1 expression.
-
ReturnOne2
on ReturnOne<
(Expr< A> , Expr<B> )> - Extension methods for a statement returning exactly one row with 2 expressions.
-
ReturnOne3
on ReturnOne<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a statement returning exactly one row with 3 expressions.
-
ReturnOne4
on ReturnOne<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a statement returning exactly one row with 4 expressions.
-
ReturnOne5
on ReturnOne<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a statement returning exactly one row with 5 expressions.
-
ReturnOne6
on ReturnOne<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a statement returning exactly one row with 6 expressions.
-
ReturnOne7
on ReturnOne<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a statement returning exactly one row with 7 expressions.
-
ReturnOne8
on ReturnOne<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a statement returning exactly one row with 8 expressions.
-
ReturnSingle1
on ReturnSingle<
(Expr< A> )> - Extension methods for a statement returning at-most one row with 1 expression.
-
ReturnSingle2
on ReturnSingle<
(Expr< A> , Expr<B> )> - Extension methods for a statement returning at-most one row with 2 expressions.
-
ReturnSingle3
on ReturnSingle<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a statement returning at-most one row with 3 expressions.
-
ReturnSingle4
on ReturnSingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a statement returning at-most one row with 4 expressions.
-
ReturnSingle5
on ReturnSingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a statement returning at-most one row with 5 expressions.
-
ReturnSingle6
on ReturnSingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a statement returning at-most one row with 6 expressions.
-
ReturnSingle7
on ReturnSingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a statement returning at-most one row with 7 expressions.
-
ReturnSingle8
on ReturnSingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a statement returning at-most one row with 8 expressions.
-
RightJoin1On1
on RightJoin<
(Expr< A> ), (Expr<B> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin1On2
on RightJoin<
(Expr< A> ), (Expr<B> , Expr<C> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin1On3
on RightJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin1On4
on RightJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin1On5
on RightJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin1On6
on RightJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin1On7
on RightJoin<
(Expr< A> ), (Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin2On1
on RightJoin<
(Expr< A> , Expr<B> ), (Expr<C> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin2On2
on RightJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin2On3
on RightJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin2On4
on RightJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin2On5
on RightJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin2On6
on RightJoin<
(Expr< A> , Expr<B> ), (Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin3On1
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin3On2
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin3On3
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin3On4
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin3On5
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> ), (Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin4On1
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin4On2
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin4On3
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin4On4
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), (Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin5On1
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin5On2
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin5On3
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), (Expr<F> , Expr<G> , Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin6On1
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin6On2
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), (Expr<G> , Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. -
RightJoin7On1
on RightJoin<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), (Expr<H> )> -
Extension methods for completing an
RIGHT JOIN
. - StringExt on T
- Extension methods for wrapping a String as an expression.
-
SubQuery1
on SubQuery<
(Expr< A> )> - Extension methods for a subquery returning zero or more rows with 1 expression.
-
SubQuery1Ext
on SubQuery<
(Expr< T> )> - Extension methods for subqueries projected to a single expression.
-
SubQuery2
on SubQuery<
(Expr< A> , Expr<B> )> - Extension methods for a subquery returning zero or more rows with 2 expressions.
-
SubQuery3
on SubQuery<
(Expr< A> , Expr<B> , Expr<C> )> - Extension methods for a subquery returning zero or more rows with 3 expressions.
-
SubQuery4
on SubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> - Extension methods for a subquery returning zero or more rows with 4 expressions.
-
SubQuery5
on SubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> - Extension methods for a subquery returning zero or more rows with 5 expressions.
-
SubQuery6
on SubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> - Extension methods for a subquery returning zero or more rows with 6 expressions.
-
SubQuery7
on SubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> - Extension methods for a subquery returning zero or more rows with 7 expressions.
-
SubQuery8
on SubQuery<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> - Extension methods for a subquery returning zero or more rows with 8 expressions.
-
SubQueryDateTime
on SubQuery<
(Expr< DateTime?> )> - Extension methods for subqueries projected to a DateTime expression.
-
SubQueryInteger
on SubQuery<
(Expr< int?> )> - Extension methods for subqueries projected to an int expression.
-
SubQueryReal
on SubQuery<
(Expr< double?> )> - Extension methods for subqueries projected to a double expression.
-
SubQueryString
on SubQuery<
(Expr< String?> )> - Extension methods for subqueries projected to a String expression.
- Uint8ListExt on T
- Extension methods for wrapping an Uint8List as an expression.
Functions
-
toExpr<
T extends Object?> (T value) → Expr< Inserting rows Writing queries Update and deleteT> -
Create an Expr<T> wrapping
value
.
Exceptions / Errors
- AuthenticationException Exceptions
- Thrown when authentication with the database failed.
- ConstraintViolationException Exceptions
- Thrown when an operation was aborted because a constraint violation in the database.
- DatabaseConnectionBrokenException Exceptions
- Thrown when the database connection was broken.
- DatabaseConnectionException Exceptions
- Thrown when there is an issue with the database connection.
- DatabaseConnectionForceClosedException Exceptions
- Thrown when the database connection is force closed.
- DatabaseConnectionRefusedException Exceptions
- Thrown when the database connection was refused.
- DatabaseConnectionTimeoutException Exceptions
- Thrown when a connection timeout happened.
- DatabaseException Exceptions
-
Base class for all exceptions thrown by
package:typed_sql
. - DivisionByZeroException Exceptions
- Thrown when a division by zero happened in the database.
- IntermittentConnectionException Exceptions
- Thrown when there is an intermittent issue with the database connection.
- OperationException Exceptions
- Thrown when the database reports an error while executing an operation.
- TransactionAbortedException Exceptions
- Thrown when a transaction was rolled back.
- TypeCastException Exceptions
- Thrown when an SQL type cast fail in the database.
- UnspecifiedOperationException Exceptions
- An unspecified OperationException.