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

# TursoDatabase

> Base class for Turso databases. Inherit from this class and add              `TursoDbSet`1` properties for each entity type.

## Definition

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

**Namespace:** CloudNimble.BlazorEssentials.TursoDb

**Inheritance:** System.Object

## Syntax

```csharp theme={"dark"}
CloudNimble.BlazorEssentials.TursoDb.TursoDatabase
```

## Summary

Base class for Turso databases. Inherit from this class and add
`TursoDbSet`1\` properties for each entity type.

## Examples

```csharp theme={"dark"}
public class AppDatabase : TursoDatabase
{
    public TursoDbSet<User> Users { get; }
    public TursoDbSet<Post> Posts { get; }

    public AppDatabase(IJSRuntime jsRuntime) : base(jsRuntime)
    {
        Name = "app.db";
        Users = new TursoDbSet<User>(this);
        Posts = new TursoDbSet<Post>(this);
    }
}
```

## Constructors

### <Icon icon="hammer" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> .ctor <Badge color="gray">Inherited</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

## Properties

### <Icon icon="tag" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> AuthToken

Gets or sets the authentication token for remote Turso databases.

#### Syntax

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

#### Property Value

Type: `string?`

### <Icon icon="tag" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> AutoCreateSchema

Gets or sets whether to automatically create tables on connect.

#### Syntax

```csharp theme={"dark"}
public bool AutoCreateSchema { get; set; }
```

#### Property Value

Type: `bool`

### <Icon icon="tag" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> DbSets

Gets the list of DbSets in this database.

#### Syntax

```csharp theme={"dark"}
public System.Collections.Generic.List<CloudNimble.BlazorEssentials.TursoDb.ITursoDbSet> DbSets { get; }
```

#### Property Value

Type: `System.Collections.Generic.List<CloudNimble.BlazorEssentials.TursoDb.ITursoDbSet>`

### <Icon icon="tag" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> IsConnected

Gets whether the database is currently connected.

#### Syntax

```csharp theme={"dark"}
public bool IsConnected { get; }
```

#### Property Value

Type: `bool`

### <Icon icon="tag" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> Name

Gets or sets the database name/identifier.
This is used as the connection key in JavaScript.

#### Syntax

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

#### Property Value

Type: `string`

### <Icon icon="tag" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> Url

Gets or sets the database URL.
Use ":memory:" for in-memory, "file:name.db" for local file, or a Turso cloud URL.

#### Syntax

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

#### Property Value

Type: `string`

## Methods

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> BeginTransactionAsync

Begins a new database transaction.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoTransaction> BeginTransactionAsync()
```

#### Returns

Type: `System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoTransaction>`
A transaction that can be committed or rolled back.

#### Examples

```csharp theme={"dark"}
await using var transaction = await Database.BeginTransactionAsync();
try
{
    await Database.Users.AddAsync(user);
    await transaction.CommitAsync();
}
catch
{
    await transaction.RollbackAsync();
    throw;
}
```

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> ConnectAsync

Connects to the database.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task ConnectAsync()
```

#### Returns

Type: `System.Threading.Tasks.Task`
A task representing the asynchronous operation.

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> DisconnectAsync

Disconnects from the database.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task DisconnectAsync()
```

#### Returns

Type: `System.Threading.Tasks.Task`
A task representing the asynchronous operation.

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> DisposeAsync

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.ValueTask DisposeAsync()
```

#### Returns

Type: `System.Threading.Tasks.ValueTask`

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> EnsureConnectedAsync

Ensures the database is connected, connecting if necessary.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task EnsureConnectedAsync()
```

#### Returns

Type: `System.Threading.Tasks.Task`

### <Icon icon="code-fork" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> Equals <Badge color="gray">Inherited</Badge> <Badge color="orange">Virtual</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Parameters

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

#### Returns

Type: `bool`

### <Icon icon="thumbtack" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> Equals <Badge color="gray">Inherited</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Parameters

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

#### Returns

Type: `bool`

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> ExecuteAsync

Executes a SQL statement and returns the result.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult> ExecuteAsync(string sql, params object[] parameters)
```

#### Parameters

| Name         | Type        | Description                           |
| ------------ | ----------- | ------------------------------------- |
| `sql`        | `string`    | The SQL statement to execute.         |
| `parameters` | `object?[]` | The parameters for the SQL statement. |

#### Returns

Type: `System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoResult>`
The execution result.

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> ExecuteBatchAsync

Executes multiple SQL statements in a batch.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<System.Collections.Generic.List<CloudNimble.BlazorEssentials.TursoDb.TursoResult>> ExecuteBatchAsync(params (string, object[])[] statements)
```

#### Parameters

| Name         | Type                    | Description                |
| ------------ | ----------------------- | -------------------------- |
| `statements` | `(string, object?[])[]` | The statements to execute. |

#### Returns

Type: `System.Threading.Tasks.Task<System.Collections.Generic.List<CloudNimble.BlazorEssentials.TursoDb.TursoResult>>`
The results of each statement.

### <Icon icon="code-fork" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> GetHashCode <Badge color="gray">Inherited</Badge> <Badge color="orange">Virtual</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Returns

Type: `int`

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> GetType <Badge color="gray">Inherited</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Returns

Type: `System.Type`

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> MemberwiseClone <Badge color="gray">Inherited</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Returns

Type: `object`

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> Prepare

Creates a prepared statement for queries that return results.

#### Syntax

```csharp theme={"dark"}
public CloudNimble.BlazorEssentials.TursoDb.TursoPreparedStatement<TResult> Prepare<TResult>(string sql) where TResult : class, new()
```

#### Parameters

| Name  | Type     | Description               |
| ----- | -------- | ------------------------- |
| `sql` | `string` | The SQL query to prepare. |

#### Returns

Type: `CloudNimble.BlazorEssentials.TursoDb.TursoPreparedStatement<TResult>`
A prepared statement that can be executed multiple times.

#### Type Parameters

* `TResult` - The type of result returned by the query.

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> Prepare

Creates a prepared statement for non-query commands.

#### Syntax

```csharp theme={"dark"}
public CloudNimble.BlazorEssentials.TursoDb.TursoPreparedStatement Prepare(string sql)
```

#### Parameters

| Name  | Type     | Description                 |
| ----- | -------- | --------------------------- |
| `sql` | `string` | The SQL command to prepare. |

#### Returns

Type: `CloudNimble.BlazorEssentials.TursoDb.TursoPreparedStatement`
A prepared statement that can be executed multiple times.

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> QueryAsync

Executes a SQL query and returns all matching rows.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<System.Collections.Generic.List<T>> QueryAsync<T>(string sql, params object[] parameters)
```

#### Parameters

| Name         | Type        | Description                       |
| ------------ | ----------- | --------------------------------- |
| `sql`        | `string`    | The SQL query to execute.         |
| `parameters` | `object?[]` | The parameters for the SQL query. |

#### Returns

Type: `System.Threading.Tasks.Task<System.Collections.Generic.List<T>>`
A list of results.

#### Type Parameters

* `T` - The type to deserialize results into.

### <Icon icon="function" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> QuerySingleAsync

Executes a SQL query and returns the first matching row or null.

#### Syntax

```csharp theme={"dark"}
public System.Threading.Tasks.Task<T> QuerySingleAsync<T>(string sql, params object[] parameters)
```

#### Parameters

| Name         | Type        | Description                       |
| ------------ | ----------- | --------------------------------- |
| `sql`        | `string`    | The SQL query to execute.         |
| `parameters` | `object?[]` | The parameters for the SQL query. |

#### Returns

Type: `System.Threading.Tasks.Task<T?>`
The first result or default.

#### Type Parameters

* `T` - The type to deserialize the result into.

### <Icon icon="thumbtack" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> ReferenceEquals <Badge color="gray">Inherited</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Parameters

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

#### Returns

Type: `bool`

### <Icon icon="code-fork" iconType="duotone" color="#419AC5" size={24} className="mr-2" /> ToString <Badge color="gray">Inherited</Badge> <Badge color="orange">Virtual</Badge>

<Note>Inherited from `object`</Note>

#### Syntax

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

#### Returns

Type: `string?`

## Related APIs

* System.IAsyncDisposable