Definition
Assembly: CloudNimble.BlazorEssentials.TursoDb.dll Namespace: CloudNimble.BlazorEssentials.TursoDb Inheritance: System.ObjectSyntax
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 theTursoDbSet1` class.
Syntax
Parameters
| Name | Type | Description |
|---|---|---|
database | CloudNimble.BlazorEssentials.TursoDb.TursoDatabase | The parent database. |
Exceptions
| Exception | Description |
|---|---|
ArgumentNullException | Thrown when database is null. |
.ctor Inherited
Inherited from
objectSyntax
Properties
Database
Gets the parent database.Syntax
Property Value
Type:CloudNimble.BlazorEssentials.TursoDb.TursoDatabase
TableName
Gets the table name for this entity type.Syntax
Property Value
Type:string
Methods
AddAsync
Adds a new entity to the table.Syntax
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
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
Returns
Type:System.Threading.Tasks.Task<int>
The count of entities.
Equals Inherited Virtual
Inherited from
objectSyntax
Parameters
| Name | Type | Description |
|---|---|---|
obj | object? | - |
Returns
Type:bool
Equals Inherited
Inherited from
objectSyntax
Parameters
| Name | Type | Description |
|---|---|---|
objA | object? | - |
objB | object? | - |
Returns
Type:bool
FindAsync
Finds an entity by its primary key.Syntax
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
Returns
Type:System.Threading.Tasks.Task<TEntity?>
The first entity or null.
FromSqlAsync
Executes a raw SQL query against this entity’s table.Syntax
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.
GetEntityMetadata
Syntax
Returns
Type:CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata
GetHashCode Inherited Virtual
Inherited from
objectSyntax
Returns
Type:int
GetType Inherited
Inherited from
objectSyntax
Returns
Type:System.Type
MemberwiseClone Inherited
Inherited from
objectSyntax
Returns
Type:object
OrderBy
Creates a query builder with an initial ORDER BY clause (ascending).Syntax
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
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
Returns
Type:CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>
A query builder for fluent query construction.
ReferenceEquals Inherited
Inherited from
objectSyntax
Parameters
| Name | Type | Description |
|---|---|---|
objA | object? | - |
objB | object? | - |
Returns
Type:bool
RemoveAsync
Removes an entity from the table.Syntax
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
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
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
Returns
Type:System.Threading.Tasks.Task<System.Collections.Generic.List<TEntity>>
A list of all entities.
ToString Inherited Virtual
Inherited from
objectSyntax
Returns
Type:string?
UpdateAsync
Updates an existing entity in the table.Syntax
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
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.
Related APIs
- CloudNimble.BlazorEssentials.TursoDb.ITursoDbSet