ethndark / mvpsummittasklist

Example in MVP summit of using connected services and adding (persisted) SQLite to Blazor Wasm.

MvpSummitTaskList

This project was first shown at the 2022 Global MVP summit. It contains a Blazor Server and a Blazor WebAssembly project with shared UI using a Razor Class Library.

It is intended to demonstrate two features.

Visual Studio Tooling for EF Core Migrations

Starting with Visual Studio 2022 17.2 preview 2, you can create migrations and update your database without going to the command line! See step-by-step: EF Core Migrations in Visual Studio 2022 for more.

🎬Video: EF Core Migrations in Visual Studio 2022

SQLite (Persisted) in the Browser

Steven Sanderson's Blaze Orbital demo showcased SQLite in the browser. He custom built a native WASM SQLite client, modified the project template to include a native file reference and used IndexDb with a timer to save the database.

This demo takes advantage of Erik Sink's updates to his SQLite PCL client to easily add the WASM support, then uses a custom factory and the SavedChanges event to persist using browser cache storage. See step-by-step: SQLite with EF Core in the Browser for more.

🎬Video: EF Core and SQLite in Blazor Wasm