> ## 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.

# TursoSyncDatabase

> Base class for sync-enabled Turso databases. Extends [TursoDatabase](/blazoressentials/api-reference/CloudNimble/BlazorEssentials/TursoDb/TursoDatabase)              with Tur...

## Definition

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

**Namespace:** CloudNimble.BlazorEssentials.TursoDb

**Inheritance:** CloudNimble.BlazorEssentials.TursoDb.TursoDatabase

## Syntax

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

## Summary

Base class for sync-enabled Turso databases. Extends [TursoDatabase](https://easyaf.nimbleapps.cloud/blazoressentials/api-reference/CloudNimble/BlazorEssentials/TursoDb/TursoDatabase.md)
with Turso Cloud synchronization capabilities (pull, push, sync).

## Examples

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

    public AppDatabase(IJSRuntime jsRuntime) : base(jsRuntime)
    {
        Name = "app.db";
        SyncUrl = "libsql://mydb-myorg.turso.io";
        SyncAuthToken = "your-auth-token";
        Users = new TursoDbSet<User>(this);
    }
}

// Usage
await Database.ConnectAsync();
await Database.PullAsync();   // Pull changes from cloud
// ... make local changes ...
await Database.PushAsync();   // Push local changes to cloud
```

## Constructors

###  .ctor Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Initializes a new instance of the [TursoDatabase](https://easyaf.nimbleapps.cloud/blazoressentials/api-reference/CloudNimble/BlazorEssentials/TursoDb/TursoDatabase.md) class.

#### Syntax

```csharp theme={"dark"}
protected TursoDatabase(Microsoft.JSInterop.IJSRuntime jsRuntime)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `jsRuntime` | `Microsoft.JSInterop.IJSRuntime` | The JavaScript runtime for interop. |

#### Exceptions

| Exception | Description |
| - | - |
| `ArgumentNullException` | Thrown when jsRuntime is null. |

###  .ctor Inherited

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

#### Syntax

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

## Properties

###  AuthToken Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Gets or sets the authentication token for remote Turso databases.

#### Syntax

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

#### Property Value

Type: `string?`

###  AutoCreateSchema Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Gets or sets whether to automatically create tables on connect.

#### Syntax

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

#### Property Value

Type: `bool`

###  DbSets Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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>`

### &#x20;EncryptionEnabled

Gets or sets whether encryption is enabled for the local database.

#### Syntax

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

#### Property Value

Type: `bool`

### &#x20;EncryptionKey

Gets or sets the encryption key for the local database.

#### Syntax

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

#### Property Value

Type: `string?`

### &#x20;IsConnected Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Gets whether the database is currently connected.

#### Syntax

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

#### Property Value

Type: `bool`

### &#x20;IsSyncing

Gets whether a sync operation is currently in progress.

#### Syntax

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

#### Property Value

Type: `bool`

### &#x20;Name Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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`

### &#x20;SyncAuthToken

Gets or sets the authentication token for Turso Cloud sync.

#### Syntax

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

#### Property Value

Type: `string`

### &#x20;SyncIntervalMs

Gets or sets the sync interval in milliseconds.
Set to 0 to disable automatic periodic sync. Default is 0.

#### Syntax

```csharp theme={"dark"}
public int SyncIntervalMs { get; set; }
```

#### Property Value

Type: `int`

### &#x20;SyncOnConnect

Gets or sets whether to sync on connect.
Default is true.

#### Syntax

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

#### Property Value

Type: `bool`

### &#x20;SyncUrl

Gets or sets the sync URL for Turso Cloud.
This is typically in the format: libsql://\[database-name]-\[org-name].turso.io

#### Syntax

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

#### Property Value

Type: `string`

### &#x20;Url Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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

### &#x20;BeginTransactionAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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;
}
```

### &#x20;CallJavaScriptAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Calls a JavaScript function in the Turso module.

#### Syntax

```csharp theme={"dark"}
internal System.Threading.Tasks.Task CallJavaScriptAsync(string functionName, params object[] args)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `functionName` | `string` | - |
| `args` | `object?[]` | - |

#### Returns

Type: `System.Threading.Tasks.Task`

### &#x20;CallJavaScriptAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Calls a JavaScript function in the Turso module and returns the result.

#### Syntax

```csharp theme={"dark"}
internal System.Threading.Tasks.Task<TResult> CallJavaScriptAsync<TResult>(string functionName, params object[] args)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `functionName` | `string` | - |
| `args` | `object?[]` | - |

#### Returns

Type: `System.Threading.Tasks.Task<TResult>`

### &#x20;ConnectAsync

Connects to the database with sync support.
If [TursoSyncDatabase.SyncOnConnect](https://easyaf.nimbleapps.cloud/blazoressentials/api-reference/CloudNimble/BlazorEssentials/TursoDb/TursoSyncDatabase.md#synconconnect) is true, performs an initial sync after connecting.

#### Syntax

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

#### Returns

Type: `System.Threading.Tasks.Task`

### &#x20;ConnectAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#x20;DisconnectAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#x20;DisposeAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

#### Syntax

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

#### Returns

Type: `System.Threading.Tasks.ValueTask`

### &#x20;EnsureConnectedAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

Ensures the database is connected, connecting if necessary.

#### Syntax

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

#### Returns

Type: `System.Threading.Tasks.Task`

### &#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;ExecuteAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#x20;ExecuteBatchAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#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;Prepare Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#x20;Prepare Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#x20;PullAsync

Pulls changes from Turso Cloud to the local database.
This downloads any changes made on other devices or the cloud.

#### Syntax

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

#### Returns

Type: `System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoSyncResult>`
The sync result containing the number of frames synced.

### &#x20;PushAsync

Pushes local changes to Turso Cloud.
This uploads any local changes to the cloud for other devices to sync.

#### Syntax

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

#### Returns

Type: `System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoSyncResult>`
The sync result containing the number of frames synced.

### &#x20;QueryAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#x20;QuerySingleAsync Inherited

> [!NOTE]
>
> Inherited from `CloudNimble.BlazorEssentials.TursoDb.TursoDatabase`

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.

### &#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;SyncAsync

Performs a bidirectional sync with Turso Cloud.
This combines pull and push operations.

#### Syntax

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

#### Returns

Type: `System.Threading.Tasks.Task<CloudNimble.BlazorEssentials.TursoDb.TursoSyncResult>`
The sync result containing the number of frames synced.

### &#x20;ToString Inherited Virtual

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

#### Syntax

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

#### Returns

Type: `string?`

## Events

### &#x20;SyncCompleted

Occurs when a sync operation completes successfully.

#### Syntax

```csharp theme={"dark"}
public System.EventHandler<CloudNimble.BlazorEssentials.TursoDb.TursoSyncResult> SyncCompleted
```

### &#x20;SyncFailed

Occurs when a sync operation fails.

#### Syntax

```csharp theme={"dark"}
public System.EventHandler<System.Exception> SyncFailed
```

### &#x20;SyncStarted

Occurs when a sync operation starts.

#### Syntax

```csharp theme={"dark"}
public System.EventHandler SyncStarted
```

## Related APIs

* System.IAsyncDisposable


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