[Epic] Offline-first Dashboard with browser SQLite (blocked pending Path A/B decision)

[MelbourneDeveloper]

Problem Statement

Dashboard.Web needs browser-based SQLite for offline-first operation. This requires sharing DataProvider-generated code between backend (net9.0) and frontend (H5/netstandard2.0).

Current Blocker

BLOCKED until we determine Path A or Path B:

• Path A: H5 supports netstandard2.1 APIs → DataProvider stays net9.0, multi-target to ns2.1
• Path B: H5 only supports netstandard2.0 APIs → DataProvider must downgrade to ns2.0 APIs

Desired Outcome

1. Browser SQLite (sql.js or wa-sqlite)
2. Shared DataProvider-generated records in frontend
3. Offline query execution
4. Bidirectional sync with conflict resolution
5. Online/offline UI indicators

Success Criteria

• Dashboard loads cached data when offline
• User can browse ICD-10, patients, appointments offline
• Offline changes sync when connected
• Shared type-safe records work in both backend and frontend

Dependencies

• BLOCKED until Path A or Path B is chosen and implemented