SQLite.TableQuery< T > Class Template Reference

Inheritance diagram for SQLite.TableQuery< T >:

Public Member Functions
	TableQuery (SQLiteConnection conn)
TableQuery< U >	Clone< U > ()
TableQuery< T >	Where (Expression< Func< T, bool > > predExpr)
TableQuery< T >	Take (int n)
TableQuery< T >	Skip (int n)
T	ElementAt (int index)
TableQuery< T >	Deferred ()
TableQuery< T >	OrderBy< U > (Expression< Func< T, U > > orderExpr)
TableQuery< T >	OrderByDescending< U > (Expression< Func< T, U > > orderExpr)
TableQuery< T >	ThenBy< U > (Expression< Func< T, U > > orderExpr)
TableQuery< T >	ThenByDescending< U > (Expression< Func< T, U > > orderExpr)
TableQuery< TResult >	Join< TInner, TKey, TResult > (TableQuery< TInner > inner, Expression< Func< T, TKey > > outerKeySelector, Expression< Func< TInner, TKey > > innerKeySelector, Expression< Func< T, TInner, TResult > > resultSelector)
TableQuery< TResult >	Select< TResult > (Expression< Func< T, TResult > > selector)
int	Count ()
int	Count (Expression< Func< T, bool > > predExpr)
IEnumerator< T >	GetEnumerator ()
T	First ()
T	FirstOrDefault ()

Properties
SQLiteConnection	Connection [get]
TableMapping	Table [get]
string	CommandText [get, set]
object	Value [get, set]

Member Function Documentation

Clone< U >()

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

(

)

Count() [1/2]

int SQLite.TableQuery< T >.Count

(

)

Count() [2/2]

int SQLite.TableQuery< T >.Count

(

Expression< Func< T, bool > >

predExpr

)

Deferred()

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

(

)

ElementAt()

T SQLite.TableQuery< T >.ElementAt

(

int

index

)

First()

T SQLite.TableQuery< T >.First

(

)

FirstOrDefault()

T SQLite.TableQuery< T >.FirstOrDefault

(

)

GetEnumerator()

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

(

)

Join< TInner, TKey, TResult >()

TableQuery< TResult > SQLite.TableQuery< T >.Join< TInner, TKey, TResult >	(	TableQuery< TInner >	inner,
		Expression< Func< T, TKey > >	outerKeySelector,
		Expression< Func< TInner, TKey > >	innerKeySelector,
		Expression< Func< T, TInner, TResult > >	resultSelector )

OrderBy< U >()

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

(

Expression< Func< T, U > >

orderExpr

)

OrderByDescending< U >()

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

(

Expression< Func< T, U > >

orderExpr

)

Select< TResult >()

TableQuery< TResult > SQLite.TableQuery< T >.Select< TResult >

(

Expression< Func< T, TResult > >

selector

)

Skip()

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

(

int

n

)

TableQuery()

SQLite.TableQuery< T >.TableQuery

(

SQLiteConnection

conn

)

Take()

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

(

int

n

)

ThenBy< U >()

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

(

Expression< Func< T, U > >

orderExpr

)

ThenByDescending< U >()

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

(

Expression< Func< T, U > >

orderExpr

)

Where()

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

(

Expression< Func< T, bool > >

predExpr

)

Property Documentation

CommandText

string SQLite.TableQuery< T >.CommandText

getset

Connection

SQLiteConnection SQLite.TableQuery< T >.Connection

get

Table

TableMapping SQLite.TableQuery< T >.Table

get

Value

object SQLite.TableQuery< T >.Value

getset