JustyBase.Sqlite 0.8.2

dotnet add package JustyBase.Sqlite --version 0.8.2
                    
NuGet\Install-Package JustyBase.Sqlite -Version 0.8.2
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="JustyBase.Sqlite" Version="0.8.2" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="JustyBase.Sqlite" Version="0.8.2" />
                    
Directory.Packages.props
<PackageReference Include="JustyBase.Sqlite" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add JustyBase.Sqlite --version 0.8.2
                    
#r "nuget: JustyBase.Sqlite, 0.8.2"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package JustyBase.Sqlite@0.8.2
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=JustyBase.Sqlite&version=0.8.2
                    
Install as a Cake Addin
#tool nuget:?package=JustyBase.Sqlite&version=0.8.2
                    
Install as a Cake Tool

JustyBase.Sqlite

UI-agnostic SQLite metadata, parser schema, and DDL integration components for the JustyBase SQL tooling stack.

Components

  • Schema/SqliteSchemaLoader — reads PRAGMA database_list, sqlite_schema and PRAGMA table_info over any ADO.NET DbConnection (Microsoft.Data.Sqlite, System.Data.SQLite, ODBC, test doubles) and produces host-neutral SqliteSchemaSnapshot values.
  • Schema/SqliteSchemaCache — per-connection/per-database snapshot cache with TTL freshness and a monotonic generation counter.
  • Schema/SqliteSchemaProviderAdapter — loads snapshots into the parser's InMemorySchemaProvider so completion and semantic validation can resolve main.table-style names.
  • Ddl/SqliteDdlGenerator — canonical CREATE TABLE generation from a snapshot (inline single-column PRIMARY KEY, table-level composite keys, NOT NULL and DEFAULT clauses).
  • Diagnostics/SqliteErrorLocator — maps SQLite error messages (near "X": syntax error, no such table: t, ...) to the token to highlight.
  • DependencyInjection/ServiceCollectionExtensionsAddJustyBaseSqlite().

Usage

using JustyBase.Sqlite.Schema;
using Microsoft.Data.Sqlite;

await using var connection = new SqliteConnection("Data Source=:memory:");
await connection.OpenAsync();

var snapshot = await SqliteSchemaLoader.LoadCatalogAsync(connection, "main");
var ddl = SqliteDdlGenerator.CreateTable(snapshot.Tables[0]);
Product Compatible and additional computed target framework versions.
.NET net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
0.8.2 85 8/16/2026