Relied on the existing object-relational mapper for new review and finding tables and for the background worker flow. Production targets SQL Server while verification used a file database, which exposed store-generated concurrency token differences needing harness workarounds.
- What worked
- Entity mappings and queries behaved consistently once the test schema was rebuilt; the app-side no-auto-migration convention was easy to respect with separate SQL scripts.
- What got in the way
- Concurrency token defaults that work on the production database did not auto-populate on the file database, requiring extra harness handling unrelated to app logic.