sqlite-net-pcl by Frank A. Krueger

<PackageReference Include="sqlite-net-pcl" Version="1.6.292" />

.NET API 89,600 bytes

 AsyncTableQuery<T>

public class AsyncTableQuery<T>
Query to an asynchronous database connection.
public AsyncTableQuery(TableQuery<T> innerQuery)

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

public Task<int> CountAsync()

Execute SELECT COUNT(*) on the query

public Task<int> CountAsync(Expression<Func<T, bool>> predExpr)

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

public Task<int> DeleteAsync(Expression<Func<T, bool>> predExpr)

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

public Task<int> DeleteAsync()

Delete all the rows that match this query.

public Task<T> ElementAtAsync(int index)

Returns the element at a given index

public Task<T> FirstAsync()

Returns the first element of this query.

public Task<T> FirstAsync(Expression<Func<T, bool>> predExpr)

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

public Task<T> FirstOrDefaultAsync()

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

public Task<T> FirstOrDefaultAsync(Expression<Func<T, bool>> predExpr)

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

public AsyncTableQuery<T> OrderBy<U>(Expression<Func<T, U>> orderExpr)

Order the query results according to a key.

public AsyncTableQuery<T> OrderByDescending<U>(Expression<Func<T, U>> orderExpr)

Order the query results according to a key.

public AsyncTableQuery<T> Skip(int n)

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

public AsyncTableQuery<T> Take(int n)

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

public AsyncTableQuery<T> ThenBy<U>(Expression<Func<T, U>> orderExpr)

Order the query results according to a key.

public AsyncTableQuery<T> ThenByDescending<U>(Expression<Func<T, U>> orderExpr)

Order the query results according to a key.

public Task<T[]> ToArrayAsync()

Queries the database and returns the results as an array.

public Task<List<T>> ToListAsync()

Queries the database and returns the results as a List.

public AsyncTableQuery<T> Where(Expression<Func<T, bool>> predExpr)

Filters the query based on a predicate.