Start Debugging

Tag: sqlite

3 posts

2026-09-27 ef-core ef-core-11 sql-server

How to add a unique index on a JSON-mapped property in EF Core 11 (SQL Server and SQLite)

HasIndex(...).IsUnique() on a ToJson() member does not enforce uniqueness in EF Core 11 RC 1: SQL Server drops IsUnique and SQLite indexes the whole document. Expose the JSON value as a computed column and put the unique index on that instead.

2026-02-07 dotnet flutter sqlite

TrailBase v0.23.7: A Single-Binary Firebase Alternative for .NET 10 and Flutter

TrailBase is an open-source, single-executable backend built on Rust, SQLite, and Wasmtime. Version 0.23.7 ships UI fixes and improved error handling.

2023-09-01 sqlite

SQLite-net – No parameterless constructor defined for this object on ExecuteQuery

How to fix the 'no parameterless constructor defined' error in SQLite-net when using ExecuteQuery with primitive types like string or int.