Store In Local Database When Remote Sql Server Unavailable And Then Sync When Connected

I am developing a C# Windows Forms app for event management. There will be 15 gates with RFID readers. These readers will read the UID and query the database to check if it is uniq

Solution 1:

You could use SQL Server replication, and install SQL Server Express with a local copy of the database on each device.