SQLite Database Connection (SqliteDatabaseConnection) Class

Namespace: Cxt.Account.Settings.API.DatabaseInherits from: BaseDatabaseConnectionImplements: IDatabaseConnection (via BaseDatabaseConnection)

Concrete IDatabaseConnection for SQLite, using Microsoft.Data.Sqlite.

Purpose

• Establishes SQLite DB connection via connection string.
• Creates SqliteCommand objects for SQLite execution. Enables the API to use SQLite (e.g., AccountSettings.db), relying on BaseDatabaseConnection for common database operation logic.

Constructor: SqliteDatabaseConnection

public SqliteDatabaseConnection(string connectionString)

• Description: Initializes a new instance of the SqliteDatabaseConnection class.
• Parameters:

  Parameter	Type	Description
  connectionString	string	The SQLite connection string (e.g., Data Source=AccountSettings.db).

• Behavior: Initializes a new Microsoft.Data.Sqlite.SqliteConnection(connectionString) and passes it to the BaseDatabaseConnection constructor.

Overridden Methods

Create Command

protected override System.Data.Common.DbCommand CreateCommand(string sql)

• Overrides: CreateCommand from BaseDatabaseConnection.
• Description: Creates and returns a Microsoft.Data.Sqlite.SqliteCommand specific to SQLite.
• Parameters:

  Parameter	Type	Description
  sql	string	The SQL string to be used for the command.

• Returns: System.Data.Common.DbCommand (specifically a Microsoft.Data.Sqlite.SqliteCommand) ready for execution.
• Behavior: Creates and returns new Microsoft.Data.Sqlite.SqliteCommand(sql, (Microsoft.Data.Sqlite.SqliteConnection)_connection).

How It Works

SqliteDatabaseConnection provides SQLite-specifics to BaseDatabaseConnection:

1. Supplies the SqliteConnection (DbConnection) to the base.
2. Defines how to create a SqliteCommand (DbCommand). All other database operations are handled by BaseDatabaseConnection but operate on these SQLite-specific objects.

Usage in the API

Registered with DI container, e.g., in Program.cs:

// Example DI registration (actual code may vary)
builder.Services.AddSingleton<IDatabaseConnection>(sp =>
{
    var configuration = sp.GetRequiredService<IConfiguration>();
    // Assumes connection string is in appsettings.json
    var connectionString = configuration.GetConnectionString("DefaultConnection");
    return new SqliteDatabaseConnection(connectionString);
});

Allows services like AccountSettingsClient to use IDatabaseConnection for SQLite interactions.