Class TableQuery<T>

Inheritance
object
BaseTableQuery
TableQuery<T>
Implements
IEnumerable<T>
Namespace: Unity.VisualScripting.Dependencies.Sqlite
Assembly: solution.dll
Syntax
public class TableQuery<T> : BaseTableQuery, IEnumerable<T>
Type Parameters
Name Description
T

Constructors

TableQuery(SQLiteConnection)

Declaration
public TableQuery(SQLiteConnection conn)
Parameters
Type Name Description
SQLiteConnection conn

Properties

Connection

Declaration
public SQLiteConnection Connection { get; }
Property Value
Type Description
SQLiteConnection

Table

Declaration
public TableMapping Table { get; }
Property Value
Type Description
TableMapping

Methods

Clone<U>()

Declaration
public TableQuery<U> Clone<U>()
Returns
Type Description
TableQuery<U>
Type Parameters
Name Description
U

Count()

Declaration
public int Count()
Returns
Type Description
int

Count(Expression<Func<T, bool>>)

Declaration
public int Count(Expression<Func<T, bool>> predExpr)
Parameters
Type Name Description
Expression<Func<T, bool>> predExpr
Returns
Type Description
int

Deferred()

Declaration
public TableQuery<T> Deferred()
Returns
Type Description
TableQuery<T>

ElementAt(int)

Declaration
public T ElementAt(int index)
Parameters
Type Name Description
int index
Returns
Type Description
T

First()

Declaration
public T First()
Returns
Type Description
T

FirstOrDefault()

Declaration
public T FirstOrDefault()
Returns
Type Description
T

GenerateCommand(string)

Declaration
public SQLiteCommand GenerateCommand(string selectionList)
Parameters
Type Name Description
string selectionList
Returns
Type Description
SQLiteCommand

GetEnumerator()

Declaration
public IEnumerator<T> GetEnumerator()
Returns
Type Description
IEnumerator<T>

Join<TInner, TKey, TResult>(TableQuery<TInner>, Expression<Func<T, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<T, TInner, TResult>>)

Declaration
public 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)
Parameters
Type Name Description
TableQuery<TInner> inner
Expression<Func<T, TKey>> outerKeySelector
Expression<Func<TInner, TKey>> innerKeySelector
Expression<Func<T, TInner, TResult>> resultSelector
Returns
Type Description
TableQuery<TResult>
Type Parameters
Name Description
TInner
TKey
TResult

OrderByDescending<U>(Expression<Func<T, U>>)

Declaration
public TableQuery<T> OrderByDescending<U>(Expression<Func<T, U>> orderExpr)
Parameters
Type Name Description
Expression<Func<T, U>> orderExpr
Returns
Type Description
TableQuery<T>
Type Parameters
Name Description
U

OrderBy<U>(Expression<Func<T, U>>)

Declaration
public TableQuery<T> OrderBy<U>(Expression<Func<T, U>> orderExpr)
Parameters
Type Name Description
Expression<Func<T, U>> orderExpr
Returns
Type Description
TableQuery<T>
Type Parameters
Name Description
U

Skip(int)

Declaration
public TableQuery<T> Skip(int n)
Parameters
Type Name Description
int n
Returns
Type Description
TableQuery<T>

Take(int)

Declaration
public TableQuery<T> Take(int n)
Parameters
Type Name Description
int n
Returns
Type Description
TableQuery<T>

ThenByDescending<U>(Expression<Func<T, U>>)

Declaration
public TableQuery<T> ThenByDescending<U>(Expression<Func<T, U>> orderExpr)
Parameters
Type Name Description
Expression<Func<T, U>> orderExpr
Returns
Type Description
TableQuery<T>
Type Parameters
Name Description
U

ThenBy<U>(Expression<Func<T, U>>)

Declaration
public TableQuery<T> ThenBy<U>(Expression<Func<T, U>> orderExpr)
Parameters
Type Name Description
Expression<Func<T, U>> orderExpr
Returns
Type Description
TableQuery<T>
Type Parameters
Name Description
U

Where(Expression<Func<T, bool>>)

Declaration
public TableQuery<T> Where(Expression<Func<T, bool>> predExpr)
Parameters
Type Name Description
Expression<Func<T, bool>> predExpr
Returns
Type Description
TableQuery<T>

Implements

IEnumerable<>

Extension Methods