Documentation Index
Fetch the complete documentation index at: https://easyaf.dev/llms.txt
Use this file to discover all available pages before exploring further.
Definition
Assembly: CloudNimble.BlazorEssentials.TursoDb.dll
Namespace: CloudNimble.BlazorEssentials.TursoDb.Query
Inheritance: System.Object
Syntax
CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
Summary
Provides fluent query building capabilities for TursoDbSet.
Type Parameters
TEntity - The entity type being queried.
Constructors
.ctor Inherited
Syntax
Methods
AnyAsync
Checks if any entities match the query.
Syntax
public System.Threading.Tasks.Task<bool> AnyAsync()
Returns
Type: System.Threading.Tasks.Task<bool>
True if any entities match.
CountAsync
Executes the query and returns the count of matching entities.
Syntax
public System.Threading.Tasks.Task<int> CountAsync()
Returns
Type: System.Threading.Tasks.Task<int>
The count of matching entities.
Equals Inherited Virtual
Syntax
public virtual bool Equals(object obj)
Parameters
| Name | Type | Description |
|---|
obj | object? | - |
Returns
Type: bool
Equals Inherited
Syntax
public static bool Equals(object objA, object objB)
Parameters
| Name | Type | Description |
|---|
objA | object? | - |
objB | object? | - |
Returns
Type: bool
FirstOrDefaultAsync
Executes the query and returns the first matching entity, or null.
Syntax
public System.Threading.Tasks.Task<TEntity> FirstOrDefaultAsync()
Returns
Type: System.Threading.Tasks.Task<TEntity?>
The first matching entity or null.
GetHashCode Inherited Virtual
Syntax
public virtual int GetHashCode()
Returns
Type: int
GetType Inherited
Syntax
public System.Type GetType()
Returns
Type: System.Type
MemberwiseClone Inherited
Syntax
protected internal object MemberwiseClone()
Returns
Type: object
OrderBy
Adds an ORDER BY clause (ascending).
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> OrderBy(string column)
Parameters
| Name | Type | Description |
|---|
column | string | The column to order by. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
OrderByDescending
Adds an ORDER BY clause (descending).
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> OrderByDescending(string column)
Parameters
| Name | Type | Description |
|---|
column | string | The column to order by. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
ReferenceEquals Inherited
Syntax
public static bool ReferenceEquals(object objA, object objB)
Parameters
| Name | Type | Description |
|---|
objA | object? | - |
objB | object? | - |
Returns
Type: bool
Skip
Skips the specified number of results.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> Skip(int count)
Parameters
| Name | Type | Description |
|---|
count | int | The number of results to skip. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
Take
Limits the number of results returned.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> Take(int count)
Parameters
| Name | Type | Description |
|---|
count | int | The maximum number of results. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
ToListAsync
Executes the query and returns all matching entities.
Syntax
public System.Threading.Tasks.Task<System.Collections.Generic.List<TEntity>> ToListAsync()
Returns
Type: System.Threading.Tasks.Task<System.Collections.Generic.List<TEntity>>
A list of matching entities.
ToString Inherited Virtual
Syntax
public virtual string ToString()
Returns
Type: string?
Where
Adds a WHERE clause to the query.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> Where(string clause, params object[] parameters)
Parameters
| Name | Type | Description |
|---|
clause | string | The WHERE clause (e.g., “name = ?” or “age > ?”). |
parameters | object?[] | The parameters for the clause. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
WhereEquals
Adds a WHERE clause for equality.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> WhereEquals(string column, object value)
Parameters
| Name | Type | Description |
|---|
column | string | The column name. |
value | object? | The value to compare. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
WhereIn
Adds a WHERE IN clause.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> WhereIn(string column, params object[] values)
Parameters
| Name | Type | Description |
|---|
column | string | The column name. |
values | object[] | The values to match. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
WhereLike
Adds a WHERE clause for LIKE matching.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> WhereLike(string column, string pattern)
Parameters
| Name | Type | Description |
|---|
column | string | The column name. |
pattern | string | The LIKE pattern (use % for wildcards). |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
WhereNotNull
Adds a WHERE clause for NOT NULL check.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> WhereNotNull(string column)
Parameters
| Name | Type | Description |
|---|
column | string | The column name. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
WhereNull
Adds a WHERE clause for NULL check.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> WhereNull(string column)
Parameters
| Name | Type | Description |
|---|
column | string | The column name. |
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
The query builder for chaining.
