TursoQueryBuilder

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

Inherited from object

Syntax

public Object()

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

Inherited from object

Syntax

public virtual bool Equals(object obj)

Parameters

Name	Type	Description
`obj`	`object?`	-

Returns

Type: bool

Equals Inherited

Inherited from object

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

Inherited from object

Syntax

public virtual int GetHashCode()

Returns

Type: int

GetType Inherited

Inherited from object

Syntax

public System.Type GetType()

Returns

Type: System.Type

MemberwiseClone Inherited

Inherited from object

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

Inherited from object

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

Inherited from object

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.

Getting Started

Guides

API Reference

​Definition

​Syntax

​Summary

​Type Parameters

​Constructors

​ .ctor Inherited

​Syntax

​Methods

​ AnyAsync

​Syntax

​Returns

​ CountAsync

​Syntax

​Returns

​ Equals Inherited Virtual

​Syntax

​Parameters

​Returns

​ Equals Inherited

​Syntax

​Parameters

​Returns

​ FirstOrDefaultAsync

​Syntax

​Returns

​ GetHashCode Inherited Virtual

​Syntax

​Returns

​ GetType Inherited

​Syntax

​Returns

​ MemberwiseClone Inherited

​Syntax

​Returns

​ OrderBy

​Syntax

​Parameters

​Returns

​ OrderByDescending

​Syntax

​Parameters

​Returns

​ ReferenceEquals Inherited

​Syntax

​Parameters

​Returns

​ Skip

​Syntax

​Parameters

​Returns

​ Take

​Syntax

​Parameters

​Returns

​ ToListAsync

​Syntax

​Returns

​ ToString Inherited Virtual

​Syntax

​Returns

​ Where

​Syntax

​Parameters

​Returns

​ WhereEquals

​Syntax

​Parameters

​Returns

​ WhereIn

​Syntax

​Parameters

​Returns

​ WhereLike

​Syntax

​Parameters

​Returns

​ WhereNotNull

Definition

Syntax

Summary

Type Parameters

Constructors

.ctor Inherited

Syntax

Methods

AnyAsync

Syntax

Returns

CountAsync

Syntax

Returns

Equals Inherited Virtual

Syntax

Parameters

Returns

Equals Inherited

Syntax

Parameters

Returns

FirstOrDefaultAsync

Syntax

Returns

GetHashCode Inherited Virtual

Syntax

Returns

GetType Inherited

Syntax

Returns

MemberwiseClone Inherited

Syntax

Returns

OrderBy

Syntax

Parameters

Returns

OrderByDescending

Syntax

Parameters

Returns

ReferenceEquals Inherited

Syntax

Parameters

Returns

Skip

Syntax

Parameters

Returns

Take

Syntax

Parameters

Returns

ToListAsync

Syntax

Returns

ToString Inherited Virtual

Syntax

Returns

Where

Syntax

Parameters

Returns

WhereEquals

Syntax

Parameters

Returns

WhereIn

Syntax

Parameters

Returns

WhereLike

Syntax

Parameters

Returns

WhereNotNull

Syntax

Parameters

Returns