SQLite.TableQuery< T > Class Template Reference

SQLite-Net queries op one table, not recursive. The function will be converted and exected to a SQL command after the .ToList() More...

Inheritance diagram for SQLite.TableQuery< T >:

Public Member Functions
	TableQuery (SQLiteConnection conn)
	Filters the query based on a predicate. More...
TableQuery< U >	Clone< U > ()
	Filters the query based on a predicate. More...
TableQuery< T >	Where (Expression< Func< T, bool >> predExpr)
	Filters the query based on a predicate. More...
int	Delete ()
	Delete all the rows that match this query. More...
int	Delete (Expression< Func< T, bool >> predExpr)
	Delete all the rows that match this query and the given predicate. More...
TableQuery< T >	Take (int n)
	Yields a given number of elements from the query and then skips the remainder. More...
TableQuery< T >	Skip (int n)
	Skips a given number of elements from the query and then yields the remainder. More...
T	ElementAt (int index)
	Returns the element at a given index More...
TableQuery< T >	Deferred ()
	Option to deferre the request More...
TableQuery< T >	OrderBy< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
TableQuery< T >	OrderByDescending< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
TableQuery< T >	ThenBy< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
TableQuery< T >	ThenByDescending< U > (Expression< Func< T, U >> orderExpr)
	Order the query results according to a key. More...
int	Count ()
	Execute SELECT COUNT(*) on the query More...
int	Count (Expression< Func< T, bool >> predExpr)
	Execute SELECT COUNT(*) on the query with an additional WHERE clause. More...
IEnumerator< T >	GetEnumerator ()
	Get a IEnumerator from the Database, used SQLiteConnection More...
List< T >	ToList ()
	Queries the database and returns the results as a List. More...
T[]	ToArray ()
	Queries the database and returns the results as an array. More...
T	First ()
	Returns the first element of this query. More...
T	FirstOrDefault ()
	Returns the first element of this query, or null if no element is found. More...
T	First (Expression< Func< T, bool >> predExpr)
	Returns the first element of this query that matches the predicate. More...
T	FirstOrDefault (Expression< Func< T, bool >> predExpr)
	Returns the first element of this query that matches the predicate, or null if no element is found. More...

Properties
SQLiteConnection	Connection [get]
	the connection to the database we use More...
TableMapping	Table [get]
	the mapping of the table we use, only one table - map More...

Detailed Description

SQLite-Net queries op one table, not recursive. The function will be converted and exected to a SQL command after the .ToList()

Template Parameters

T

Constructor & Destructor Documentation

TableQuery()

SQLite.TableQuery< T >.TableQuery

(

SQLiteConnection

conn

)

Filters the query based on a predicate.

Member Function Documentation

Clone< U >()

TableQuery<U> SQLite.TableQuery< T >.Clone< U >

(

)

Filters the query based on a predicate.

Count() [1/2]

int SQLite.TableQuery< T >.Count

(

)

Execute SELECT COUNT(*) on the query

Count() [2/2]

int SQLite.TableQuery< T >.Count

(

Expression< Func< T, bool >>

predExpr

)

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

Deferred()

TableQuery<T> SQLite.TableQuery< T >.Deferred

(

)

Option to deferre the request

Returns

Delete() [1/2]

int SQLite.TableQuery< T >.Delete

(

)

Delete all the rows that match this query.

Delete() [2/2]

int SQLite.TableQuery< T >.Delete

(

Expression< Func< T, bool >>

predExpr

)

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

ElementAt()

T SQLite.TableQuery< T >.ElementAt

(

int

index

)

Returns the element at a given index

First() [1/2]

T SQLite.TableQuery< T >.First

(

)

Returns the first element of this query.

First() [2/2]

T SQLite.TableQuery< T >.First

(

Expression< Func< T, bool >>

predExpr

)

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

FirstOrDefault() [1/2]

T SQLite.TableQuery< T >.FirstOrDefault

(

)

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

FirstOrDefault() [2/2]

T SQLite.TableQuery< T >.FirstOrDefault

(

Expression< Func< T, bool >>

predExpr

)

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

GetEnumerator()

IEnumerator<T> SQLite.TableQuery< T >.GetEnumerator

(

)

Get a IEnumerator from the Database, used SQLiteConnection

Returns

OrderBy< U >()

TableQuery<T> SQLite.TableQuery< T >.OrderBy< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

OrderByDescending< U >()

TableQuery<T> SQLite.TableQuery< T >.OrderByDescending< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

Skip()

TableQuery<T> SQLite.TableQuery< T >.Skip

(

int

n

)

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

Take()

TableQuery<T> SQLite.TableQuery< T >.Take

(

int

n

)

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

ThenBy< U >()

TableQuery<T> SQLite.TableQuery< T >.ThenBy< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

ThenByDescending< U >()

TableQuery<T> SQLite.TableQuery< T >.ThenByDescending< U >

(

Expression< Func< T, U >>

orderExpr

)

Order the query results according to a key.

ToArray()

T [] SQLite.TableQuery< T >.ToArray

(

)

Queries the database and returns the results as an array.

ToList()

List<T> SQLite.TableQuery< T >.ToList

(

)

Queries the database and returns the results as a List.

Where()

TableQuery<T> SQLite.TableQuery< T >.Where

(

Expression< Func< T, bool >>

predExpr

)

Filters the query based on a predicate.

Property Documentation

Connection

SQLiteConnection SQLite.TableQuery< T >.Connection

get

the connection to the database we use

Table

TableMapping SQLite.TableQuery< T >.Table

get

the mapping of the table we use, only one table - map

---

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

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