SQLite.AsyncTableQuery< T > Class Template Reference

Query to an asynchronous database connection. More...

Public Member Functions
	AsyncTableQuery (TableQuery< T > innerQuery)
	Creates a new async query that uses given the synchronous query. More...
AsyncTableQuery< T >	Where (Expression< Func< T, bool >> predExpr)
	Filters the query based on a predicate. More...
AsyncTableQuery< T >	Skip (int n)
	Skips a given number of elements from the query and then yields the remainder. More...
AsyncTableQuery< T >	Take (int n)
	Yields a given number of elements from the query and then skips the remainder. More...
AsyncTableQuery< T >	OrderBy< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
AsyncTableQuery< T >	OrderByDescending< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
AsyncTableQuery< T >	ThenBy< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
AsyncTableQuery< T >	ThenByDescending< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
Task< List< T > >	ToListAsync ()
	Queries the database and returns the results as a List. More...
Task< T[]>	ToArrayAsync ()
	Queries the database and returns the results as an array. More...
Task< int >	CountAsync ()
	Execute SELECT COUNT(*) on the query More...
Task< int >	CountAsync (Expression< Func< T, bool >> predExpr)
	Execute SELECT COUNT(*) on the query with an additional WHERE clause. More...
Task< T >	ElementAtAsync (int index)
	Returns the element at a given index More...
Task< T >	FirstAsync ()
	Returns the first element of this query. More...
Task< T >	FirstOrDefaultAsync ()
	Returns the first element of this query, or null if no element is found. More...
Task< T >	FirstAsync (Expression< Func< T, bool >> predExpr)
	Returns the first element of this query that matches the predicate. More...
Task< T >	FirstOrDefaultAsync (Expression< Func< T, bool >> predExpr)
	Returns the first element of this query that matches the predicate. More...
Task< int >	DeleteAsync (Expression< Func< T, bool >> predExpr)
	Delete all the rows that match this query and the given predicate. More...
Task< int >	DeleteAsync ()
	Delete all the rows that match this query. More...

Detailed Description

Query to an asynchronous database connection.

Type Constraints

T

:

new()

Constructor & Destructor Documentation

AsyncTableQuery()

SQLite.AsyncTableQuery< T >.AsyncTableQuery

(

TableQuery< T >

innerQuery

)

Creates a new async query that uses given the synchronous query.

Member Function Documentation

CountAsync() [1/2]

Task<int> SQLite.AsyncTableQuery< T >.CountAsync

(

)

Execute SELECT COUNT(*) on the query

CountAsync() [2/2]

Task<int> SQLite.AsyncTableQuery< T >.CountAsync

(

Expression< Func< T, bool >>

predExpr

)

Execute SELECT COUNT(*) on the query with an additional WHERE clause.

DeleteAsync() [1/2]

Task<int> SQLite.AsyncTableQuery< T >.DeleteAsync

(

)

Delete all the rows that match this query.

DeleteAsync() [2/2]

Task<int> SQLite.AsyncTableQuery< T >.DeleteAsync

(

Expression< Func< T, bool >>

predExpr

)

Delete all the rows that match this query and the given predicate.

ElementAtAsync()

Task<T> SQLite.AsyncTableQuery< T >.ElementAtAsync

(

int

index

)

Returns the element at a given index

FirstAsync() [1/2]

Task<T> SQLite.AsyncTableQuery< T >.FirstAsync

(

)

Returns the first element of this query.

FirstAsync() [2/2]

Task<T> SQLite.AsyncTableQuery< T >.FirstAsync

(

Expression< Func< T, bool >>

predExpr

)

Returns the first element of this query that matches the predicate.

FirstOrDefaultAsync() [1/2]

Task<T> SQLite.AsyncTableQuery< T >.FirstOrDefaultAsync

(

)

Returns the first element of this query, or null if no element is found.

FirstOrDefaultAsync() [2/2]

Task<T> SQLite.AsyncTableQuery< T >.FirstOrDefaultAsync

(

Expression< Func< T, bool >>

predExpr

)

Returns the first element of this query that matches the predicate.

OrderBy< U >()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.OrderBy< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

OrderByDescending< U >()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.OrderByDescending< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

Skip()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.Skip

(

int

n

)

Skips a given number of elements from the query and then yields the remainder.

Take()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.Take

(

int

n

)

Yields a given number of elements from the query and then skips the remainder.

ThenBy< U >()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.ThenBy< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

ThenByDescending< U >()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.ThenByDescending< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

ToArrayAsync()

Task<T[]> SQLite.AsyncTableQuery< T >.ToArrayAsync

(

)

Queries the database and returns the results as an array.

ToListAsync()

Task<List<T> > SQLite.AsyncTableQuery< T >.ToListAsync

(

)

Queries the database and returns the results as a List.

Where()

AsyncTableQuery<T> SQLite.AsyncTableQuery< T >.Where

(

Expression< Func< T, bool >>

predExpr

)

Filters the query based on a predicate.

---

The documentation for this class was generated from the following file:

• /Users/admin/Unity/SQLite-Extended/Assets/Picon-SQL/Core/SQLite/SQLiteAsync.cs