MSQLite.Wrapper.Framework 1.1.6

MSQLite.Wrapper

A high-performance, zero-dependency C++/CLI wrapper for SQLite, built specifically for .NET Framework 4.6.2+.

This library offers both low-level control and high-level ORM-style features, providing a fast and efficient bridge between your .NET application and the power of SQLite—without requiring any external dependencies or native runtime installations.

⚠️ Important: This package is built exclusively for .NET Framework 4.6.2+ x64/x86 It is not compatible with AnyCPU, ARM, or non-Windows platforms.

⚠️ Visual Studio Package Migration

After installing the NuGet package, ensure that MSQLite.Wrapper appears under your project's References node. If it shows up under Packages, right-click the project and choose:

Tools → NuGet Package Manager → Migrate packages.config to PackageReference

This migration enables proper native interop, IntelliSense, and build reliability for C++/CLI assemblies.

Features

• Zero Dependencies
  Fully self-contained. Includes the SQLite source directly—no need to ship or install additional native libraries.

• High Performance
  Built with C++/CLI to minimize overhead between managed (.NET) and native (SQLite) layers.

• Targeted Runtime Support
  Designed for .NET Framework 4.6.2 and later, with support for both x86 and x64 architectures.

• ORM-like Convenience
  Includes intuitive methods like InsertReturning, UpdateReturning, and UpsertReturning for seamless object mapping.

• Low-Level Control
  Exposes prepared Statement objects for precise parameter binding, result iteration, and query execution.

• Advanced SQLite Features
  Supports transactions, savepoints, incremental BLOB I/O, and full database backup operations.

• IntelliSense-Ready
  All public APIs are documented with XML comments for rich IntelliSense support in Visual Studio.

🔐 Integrated Encryption & Build Configuration

• Encryption support via SQLite3 Multiple Ciphers
• Compiled with AVX instruction set for enhanced performance
• ✅ All built-in extensions (e.g., compress, sqlar, zipfile) are compiled and automatically registered—no manual .load or sqlite3_*_init() calls required.
• Additionally ICU, Decimal and ieee extensions are compiled and initialized. ICU libraries are contained in the package.
• Dynamic extension loading is enabled.
• Custom build flags for optimized behavior and reduced footprint:

SQLITE_DEFAULT_FOREIGN_KEYS=1
HAVE_ISNAN=1
SQLITE_OMIT_PROGRESS_CALLBACK
SQLITE_DEFAULT_MEMSTATUS=0
SQLITE_DQS=0
SQLITE_DEFAULT_WAL_SYNCHRONOUS=1
SQLITE_OMIT_DEPRECATED
SQLITE_OMIT_SHARED_CACHE
SQLITE_MAX_EXPR_DEPTH=0
SQLITE_TEMP_STORE=2
SQLITE_CORE=1
SQLITE_ENABLE_EXTFUNC=1
SQLITE_ENABLE_UUID=1
SQLITE_ENABLE_COMPRESS=1
SQLITE_ENABLE_SQLAR=1
SQLITE_ENABLE_ZIPFILE=1
SQLITE_ENABLE_CSV=1
SQLITE3MC_USE_MINIZ=1
SQLITE_ENABLE_DBPAGE_VTAB
SQLITE_ENABLE_REGEXP
SQLITE_ENABLE_SERIES
SQLITE_ENABLE_FILEIO
SQLITE_ENABLE_VSV
SQLITE_ENABLE_SHA3
SQLITE_ENABLE_CARRAY
SQLITE_ENABLE_PERCENTILE
SQLITE_THREADSAFE=2
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_FTS3_PARENTHESIS
SQLITE_ENABLE_FTS4
SQLITE_ENABLE_FTS5
SQLITE_ENABLE_SESSION
SQLITE_ENABLE_ICU
SQLITE_ENABLE_GEOPOLY=1
SQLITE_ENABLE_JSON1=1
SQLITE_ENABLE_RTREE=1
SQLITE_ENABLE_UUID=1

FastLZ Compression

MSQLite includes built-in support for FastLZ compression via the MSQLite.Fastlz class.

byte[] compressed = Fastlz.Compress(data);
byte[] decompressed = Fastlz.Decompress(compressed);
byte[] compressedText = Fastlz.CompressString("Hello world");
string restored = Fastlz.DecompressString(compressedText);

⚠️ Ensure your project is targeting x64 or x86.

Getting Started

📂 A complete runnable example is included in the package as Program.cs.