Class TableQuery<T>

Inheritance
Object
BaseTableQuery
TableQuery<T>
Namespace: Unity.VisualScripting.Dependencies.Sqlite
Syntax
public class TableQuery<T> : BaseTableQuery, IEnumerable<T>, IEnumerable
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
Int32

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

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

Deferred()

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

ElementAt(Int32)

Declaration
public T ElementAt(int index)
Parameters
Type Name Description
Int32 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

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

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

Skip(Int32)

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

Take(Int32)

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

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

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

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

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

Extension Methods