MAUI LAN SQL Server Sync

I have a pair of .NET MAUI apps already compiled and running on our local devices; the only missing piece is a rock-solid connection layer to our on-premise SQL Server sitting on the same LAN. The apps must be able to read, write, and update data in real time without touching the public internet. What I need from you, in the next 24 hours, is a lean, well-commented integration that: • Detects the SQL Server over the local network and establishes a secure connection. • Exposes asynchronous CRUD methods our existing ViewModels can call directly. • Keeps records in sync instantly (no polling) while both app and server stay inside the LAN. • Handles dropped connections gracefully and retries without data loss. Feel free to use Entity Framework Core, SignalR, or straight [login to view URL]—whatever lets you deliver clean, reliable code fast. I’ll provide the table schema, sample data, and a test machine on the network the moment we start. When you’re done, hand over the source files plus a brief setup note so my team can plug the layer straight into our repository and hit Build. If you can jump on a quick screenshare to walk through the hand-off tomorrow, even better.

Project ID: 40252311