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
Inheritance: System.Object
Syntax
CloudNimble.BlazorEssentials.TursoDb.TursoDbSet<TEntity>
Summary
Represents a collection of entities of a specific type in the database.
Provides CRUD operations and querying capabilities.
Type Parameters
TEntity - The entity type this set manages.
Constructors
.ctor
Initializes a new instance of the TursoDbSet1` class.
Syntax
public TursoDbSet(CloudNimble.BlazorEssentials.TursoDb.TursoDatabase database)
Parameters
| Name | Type | Description |
|---|
database | CloudNimble.BlazorEssentials.TursoDb.TursoDatabase | The parent database. |
Exceptions
| Exception | Description |
|---|
ArgumentNullException | Thrown when database is null. |
.ctor Inherited
Syntax
Properties
Database
Gets the parent database.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.TursoDatabase Database { get; }
Property Value
Type: CloudNimble.BlazorEssentials.TursoDb.TursoDatabase
TableName
Gets the table name for this entity type.
Syntax
public string TableName { get; }
Property Value
Type: string
Methods
AddAsync
Adds a new entity to the table.
Syntax
public System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult> AddAsync(TEntity entity)
Parameters
| Name | Type | Description |
|---|
entity | TEntity | The entity to add. |
Returns
Type: System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult>
The execution result containing the last insert ID.
AddRangeAsync
Adds multiple entities to the table in a batch.
Syntax
public System.Threading.Tasks.Task<int> AddRangeAsync(System.Collections.Generic.IEnumerable<TEntity> entities)
Parameters
| Name | Type | Description |
|---|
entities | System.Collections.Generic.IEnumerable<TEntity> | The entities to add. |
Returns
Type: System.Threading.Tasks.Task<int>
The number of entities added.
CountAsync
Gets the count of entities in the table.
Syntax
public System.Threading.Tasks.Task<int> CountAsync()
Returns
Type: System.Threading.Tasks.Task<int>
The count of 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
FindAsync
Finds an entity by its primary key.
Syntax
public System.Threading.Tasks.Task<TEntity> FindAsync(object key)
Parameters
| Name | Type | Description |
|---|
key | object | The primary key value. |
Returns
Type: System.Threading.Tasks.Task<TEntity?>
The entity if found, otherwise null.
FirstOrDefaultAsync
Gets the first entity matching the optional filter, or null if none.
Syntax
public System.Threading.Tasks.Task<TEntity> FirstOrDefaultAsync()
Returns
Type: System.Threading.Tasks.Task<TEntity?>
The first entity or null.
FromSqlAsync
Executes a raw SQL query against this entity’s table.
Syntax
public System.Threading.Tasks.Task<System.Collections.Generic.List<TEntity>> FromSqlAsync(string sql, params object[] parameters)
Parameters
| Name | Type | Description |
|---|
sql | string | The SQL query. |
parameters | object?[] | The query parameters. |
Returns
Type: System.Threading.Tasks.Task<System.Collections.Generic.List<TEntity>>
A list of matching entities.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata GetEntityMetadata()
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata
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
Creates a query builder with an initial 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>
A query builder for fluent query construction.
OrderByDescending
Creates a query builder with an initial 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>
A query builder for fluent query construction.
Query
Creates a new query builder for this entity set.
Syntax
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> Query()
Returns
Type: CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
A query builder for fluent query construction.
ReferenceEquals Inherited
Syntax
public static bool ReferenceEquals(object objA, object objB)
Parameters
| Name | Type | Description |
|---|
objA | object? | - |
objB | object? | - |
Returns
Type: bool
RemoveAsync
Removes an entity from the table.
Syntax
public System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult> RemoveAsync(TEntity entity)
Parameters
| Name | Type | Description |
|---|
entity | TEntity | The entity to remove. |
Returns
Type: System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult>
The execution result.
RemoveByKeyAsync
Removes an entity by its primary key.
Syntax
public System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult> RemoveByKeyAsync(object key)
Parameters
| Name | Type | Description |
|---|
key | object | The primary key value. |
Returns
Type: System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult>
The execution result.
RemoveRangeAsync
Removes multiple entities from the table.
Syntax
public System.Threading.Tasks.Task<int> RemoveRangeAsync(System.Collections.Generic.IEnumerable<TEntity> entities)
Parameters
| Name | Type | Description |
|---|
entities | System.Collections.Generic.IEnumerable<TEntity> | The entities to remove. |
Returns
Type: System.Threading.Tasks.Task<int>
The number of entities removed.
ToListAsync
Retrieves all entities from the table.
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 all entities.
ToString Inherited Virtual
Syntax
public virtual string ToString()
Returns
Type: string?
UpdateAsync
Updates an existing entity in the table.
Syntax
public System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult> UpdateAsync(TEntity entity)
Parameters
| Name | Type | Description |
|---|
entity | TEntity | The entity to update. |
Returns
Type: System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult>
The execution result.
Where
Creates a query builder with an initial WHERE clause.
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>
A query builder for fluent query construction.
- CloudNimble.BlazorEssentials.TursoDb.ITursoDbSet
