Nelknet LibSQL Data

https://www.nuget.org/packages/Nelknet.LibSQL.Data
Admin
A native .NET client library for libSQL databases, providing a complete ADO.NET implementation for...
Tokens:6,703
Snippets:44
Trust Score:9.5
Update:11 months ago
Show doc for...
Tokens:
Raw
### Install Nelknet.LibSQL.Data NuGet Package

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/0

Installs the Nelknet.LibSQL.Data NuGet package using the .NET CLI or Package Manager Console. Includes instructions for installing pre-release versions.

```bash
dotnet add package Nelknet.LibSQL.Data

```

```powershell
Install-Package Nelknet.LibSQL.Data

```

```bash
dotnet add package Nelknet.LibSQL.Data --prerelease

```

--------------------------------

### Install Nelknet.LibSQL.Data via .NET CLI

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Installs the Nelknet.LibSQL.Data package using the .NET command-line interface.

```bash
dotnet add package Nelknet.LibSQL.Data

```

--------------------------------

### Install Nelknet.LibSQL.Data via Package Manager Console

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Installs the Nelknet.LibSQL.Data package using the Package Manager Console in Visual Studio.

```powershell
Install-Package Nelknet.LibSQL.Data

```

--------------------------------

### LibSQL Connection String: Local Mode (File and In-Memory)

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Examples of LibSQL connection strings for local database modes. Demonstrates how to specify a file-based database or an in-memory database.

```csharp
// File-based database
var connection = new LibSQLConnection("Data Source=mydatabase.db");

// In-memory database
var connection = new LibSQLConnection("Data Source=:memory:");

```

--------------------------------

### LibSQL Connection String: Remote Mode

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Example of a LibSQL connection string for connecting to a remote libSQL server, such as Turso. Requires the data source URL and an authentication token.

```csharp
// Connect to remote libSQL server (e.g., Turso)
var connection = new LibSQLConnection(
    "Data Source=https://mydb.turso.io;Auth Token=your-auth-token");

```

--------------------------------

### LibSQL Connection String: Embedded Replica Mode

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Example of a LibSQL connection string for an embedded replica that syncs with a remote database. Includes data source, sync URL, and authentication token.

```csharp
// Local database that syncs with remote
var connection = new LibSQLConnection(
    "Data Source=local.db;SyncUrl=https://mydb.turso.io;AuthToken=your-token");

```

--------------------------------

### Handle LibSQL Exceptions in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Provides an example of how to handle potential exceptions during database operations using LibSQL. It shows a try-catch block that specifically catches LibSQLException and its derived types like LibSQLBusyException and LibSQLConstraintException, allowing for targeted error management.

```csharp
try
{
    // Database operations
}
catch (LibSQLException ex)
{
    Console.WriteLine($"Database error: {ex.Message}");
    Console.WriteLine($"Error code: {ex.ErrorCode}");
    
    // Handle specific error types
    if (ex is LibSQLBusyException busyEx)
    {
        Console.WriteLine($"Database is busy: {busyEx.LockType}");
    }
    else if (ex is LibSQLConstraintException constraintEx)
    {
        Console.WriteLine($"Constraint violation: {constraintEx.ConstraintType}");
    }
}

```

--------------------------------

### Basic LibSQL Database Operations in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Demonstrates basic database operations including creating a table, inserting data, and querying data using the LibSQLConnection class. Requires the Nelknet.LibSQL.Data library.

```csharp
using Nelknet.LibSQL.Data;

// Create and open a connection
using var connection = new LibSQLConnection("Data Source=local.db");
connection.Open();

// Create a table
using var createCmd = connection.CreateCommand();
createCmd.CommandText = @"
    CREATE TABLE users (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL,
        email TEXT UNIQUE
    )";
createCmd.ExecuteNonQuery();

// Insert data
using var insertCmd = connection.CreateCommand();
insertCmd.CommandText = "INSERT INTO users (name, email) VALUES (@name, @email)";
insertCmd.Parameters.AddWithValue("@name", "Alice");
insertCmd.Parameters.AddWithValue("@email", "alice@example.com");
insertCmd.ExecuteNonQuery();

// Query data
using var queryCmd = connection.CreateCommand();
queryCmd.CommandText = "SELECT * FROM users";
using var reader = queryCmd.ExecuteReader();

while (reader.Read())
{
    var id = reader.GetInt32(0);
    var name = reader.GetString(1);
    var email = reader.GetString(2);
    Console.WriteLine($"User {id}: {name} ({email})");
}

```

--------------------------------

### Embedded Replica with Sync in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/0

Demonstrates setting up an embedded libSQL replica that synchronizes with a remote primary database. It includes connection string options for sync URL, auth token, and read-your-writes consistency.

```csharp
// Create an embedded replica that syncs with a remote primary
var connectionString = @"
    Data Source=local-replica.db;
    SyncUrl=libsql://your-database.turso.io;
    AuthToken=your-auth-token;
    ReadYourWrites=true";

using var connection = new LibSQLConnection(connectionString);
connection.Open();

// Sync with remote
await connection.SyncAsync();

// Perform local reads with remote consistency
using var cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM products WHERE price > 100";
using var reader = cmd.ExecuteReader();
// ... process results ...

```

--------------------------------

### Connect to a Remote libSQL Database in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/0

Shows how to establish a connection to a remote libSQL database using a connection string that includes the data source URL and authentication token.

```csharp
// Connect to a remote libSQL database
var connectionString = "Data Source=libsql://your-database.turso.io;AuthToken=your-auth-token";
using var connection = new LibSQLConnection(connectionString);
connection.Open();

// Use the connection normally...

```

--------------------------------

### Connect to a Remote LibSQL Database in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Establishes a connection to a remote libSQL database, such as one hosted on Turso. Requires a valid data source URL and authentication token.

```csharp
// Connect to a remote libSQL database
var connectionString = "Data Source=https://your-database.turso.io;Auth Token=your-auth-token";
using var connection = new LibSQLConnection(connectionString);
connection.Open();

// Use the connection normally...

```

--------------------------------

### Asynchronous Database Operations in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Shows how to perform asynchronous database operations like opening a connection and executing queries using their async counterparts (e.g., OpenAsync, ExecuteScalarAsync).

```csharp
using var connection = new LibSQLConnection("Data Source=local.db");
await connection.OpenAsync();

using var cmd = connection.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM users";
var count = await cmd.ExecuteScalarAsync();

Console.WriteLine($"Total users: {count}");

```

--------------------------------

### Using Transactions with LibSQL in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Demonstrates how to manage database transactions using BeginTransaction, Commit, and Rollback methods. Ensures atomicity for multiple database operations.

```csharp
using var connection = new LibSQLConnection("Data Source=local.db");
connection.Open();

using var transaction = connection.BeginTransaction();
try
{
    using var cmd = connection.CreateCommand();
    cmd.Transaction = transaction;
    
    // Multiple operations in a transaction
    cmd.CommandText = "UPDATE accounts SET balance = balance - 100 WHERE id = 1";
    cmd.ExecuteNonQuery();
    
    cmd.CommandText = "UPDATE accounts SET balance = balance + 100 WHERE id = 2";
    cmd.ExecuteNonQuery();
    
    transaction.Commit();
}
catch
{
    transaction.Rollback();
    throw;
}

```

--------------------------------

### Embedded LibSQL Replica with Sync in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Sets up a local embedded replica of a libSQL database that automatically syncs with a remote primary. Supports Read Your Writes consistency. Requires connection details for both local and remote databases.

```csharp
// Create an embedded replica that syncs with a remote primary
var connectionString = @"
    Data Source=local-replica.db;
    SyncUrl=https://your-database.turso.io;
    AuthToken=your-auth-token;
    ReadYourWrites=true";

using var connection = new LibSQLConnection(connectionString);
connection.Open();

// Sync with remote
await connection.SyncAsync();

// Perform local reads with remote consistency
using var cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM products WHERE price > 100";
using var reader = cmd.ExecuteReader();
// ... process results ...

```

--------------------------------

### Build LibSQL Connection String in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Demonstrates how to programmatically construct a connection string for LibSQL using the LibSQLConnectionStringBuilder class. This is useful for setting database connection details like the data source, authentication token, and statement caching options.

```csharp
var builder = new LibSQLConnectionStringBuilder
{
    DataSource = "https://mydb.turso.io",
    AuthToken = "your-auth-token",
    EnableStatementCaching = true
};

var connection = new LibSQLConnection(builder.ConnectionString);

```

--------------------------------

### Bulk Insert Operations with LibSQL in C#

Source: https://www.nuget.org/packages/Nelknet.LibSQL.Data/index

Efficiently inserts large amounts of data into a table using the LibSQLBulkInsert class. Provides methods to begin, write rows, and complete the bulk insert operation.

```csharp
var columns = new[] { "name", "email", "created_at" };
using var bulkInsert = new LibSQLBulkInsert(connection, "users", columns);

bulkInsert.BeginBulkInsert();

for (int i = 0; i < 10000; i++)
{
    bulkInsert.WriteRow(
        $"User {i}",
        $"user{i}@example.com",
        DateTime.Now.ToString("O")
    );
}

bulkInsert.Complete();

```
Tokens:
Raw