> ## Documentation Index
> Fetch the complete documentation index at: https://easyaf.nimbleapps.cloud/llms.txt
> Use this file to discover all available pages before exploring further.

# TursoDbSet

> Represents a collection of entities of a specific type in the database.             Provides CRUD operations and querying capabilities.

## Definition

**Assembly:** CloudNimble.BlazorEssentials.TursoDb.dll

**Namespace:** CloudNimble.BlazorEssentials.TursoDb

**Inheritance:** System.Object

## Syntax

```csharp theme={"dark"}
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

### &#x20;.ctor

Initializes a new instance of the `TursoDbSet`1\` class.

#### Syntax

```csharp theme={"dark"}
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. |

### &#x20;.ctor Inherited

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public Object()
```

## Properties

### &#x20;Database

Gets the parent database.

#### Syntax

```csharp theme={"dark"}
public CloudNimble.BlazorEssentials.TursoDb.TursoDatabase Database { get; }
```

#### Property Value

Type: `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

### &#x20;TableName

Gets the table name for this entity type.

#### Syntax

```csharp theme={"dark"}
public string TableName { get; }
```

#### Property Value

Type: `string`

## Methods

### &#x20;AddAsync

Adds a new entity to the table.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;AddRangeAsync

Adds multiple entities to the table in a batch.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;CountAsync

Gets the count of entities in the table.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<int> CountAsync()
```

#### Returns

Type: `System.Threading.Tasks.Task<int>`
The count of entities.

### &#x20;Equals Inherited Virtual

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public virtual bool Equals(object obj)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `obj` | `object?` | - |

#### Returns

Type: `bool`

### &#x20;Equals Inherited

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public static bool Equals(object objA, object objB)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `objA` | `object?` | - |
| `objB` | `object?` | - |

#### Returns

Type: `bool`

### &#x20;FindAsync

Finds an entity by its primary key.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;FirstOrDefaultAsync

Gets the first entity matching the optional filter, or null if none.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<TEntity> FirstOrDefaultAsync()
```

#### Returns

Type: `System.Threading.Tasks.Task<TEntity?>`
The first entity or null.

### &#x20;FromSqlAsync

Executes a raw SQL query against this entity's table.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;GetEntityMetadata

#### Syntax

```csharp theme={"dark"}
public CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata GetEntityMetadata()
```

#### Returns

Type: `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata`

### &#x20;GetHashCode Inherited Virtual

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public virtual int GetHashCode()
```

#### Returns

Type: `int`

### &#x20;GetType Inherited

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public System.Type GetType()
```

#### Returns

Type: `System.Type`

### &#x20;MemberwiseClone Inherited

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
protected internal object MemberwiseClone()
```

#### Returns

Type: `object`

### &#x20;OrderBy

Creates a query builder with an initial ORDER BY clause (ascending).

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;OrderByDescending

Creates a query builder with an initial ORDER BY clause (descending).

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;Query

Creates a new query builder for this entity set.

#### Syntax

```csharp theme={"dark"}
public CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity> Query()
```

#### Returns

Type: `CloudNimble.BlazorEssentials.TursoDb.Query.TursoQueryBuilder<TEntity>`
A query builder for fluent query construction.

### &#x20;ReferenceEquals Inherited

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public static bool ReferenceEquals(object objA, object objB)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `objA` | `object?` | - |
| `objB` | `object?` | - |

#### Returns

Type: `bool`

### &#x20;RemoveAsync

Removes an entity from the table.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;RemoveByKeyAsync

Removes an entity by its primary key.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;RemoveRangeAsync

Removes multiple entities from the table.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;ToListAsync

Retrieves all entities from the table.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;ToString Inherited Virtual

> [!NOTE]
>
> Inherited from `object`

#### Syntax

```csharp theme={"dark"}
public virtual string ToString()
```

#### Returns

Type: `string?`

### &#x20;UpdateAsync

Updates an existing entity in the table.

#### Syntax

```csharp theme={"dark"}
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.

### &#x20;Where

Creates a query builder with an initial WHERE clause.

#### Syntax

```csharp theme={"dark"}
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.

## Related APIs

* CloudNimble.BlazorEssentials.TursoDb.ITursoDbSet


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.