Skip to main content

Recruitment Database Testing Guide

Summary​

Static model, migration, snapshot, and smoke evidence can be reviewed without connecting to a database or executing migrations.

Audience​

Developers, QA and support engineers, data reviewers, implementation partners, solution architects, and security reviewers.

Overview​

Prerequisites​

Use a read-only source checkout and the approved documentation validation toolchain. Do not connect to a database, execute migrations, generate SQL, or copy configuration/seed values into review notes.

Procedure​

  1. Count DbSets and compare them with model configurations and snapshot object types.
  2. Compare primary keys, indexes, query filters, owned values, and relationships between model code and snapshot.
  3. Review each migration's declared evolution and compare the final state with the snapshot.
  4. Review repository query-filter bypasses and logical-reference queries.
  5. Review SaveChanges, audit/timeline writers, outbox translation, and relay boundaries.
  6. Use smoke source only as behavioral evidence; do not run it against an unapproved environment.

Validation or Expected Result​

The current source should reconcile to one runtime model, 18 persisted object sets, 18 primary keys, 35 snapshot indexes, 10 unique indexes, 8 cascade relationships, 2 owned values, 16 global filters, 5 migrations, and one current snapshot.

Troubleshooting​

Treat model/snapshot drift, unexpected migration changes, missing filter coverage, new filter bypasses, and relationship/index count changes as review findings. Escalate rather than repairing production data or generating SQL. A dedicated Recruitment database integration-test project is Not implemented.

Requires confirmation​

Production migration governance, rollback ownership, reconciliation, retention, privacy, performance, query optimization, concurrency, and operational ownership require confirmation.

Source References​

  • microservices/src/recruitment-service/Infrastructure/RecruitmentDbContext.cs
  • microservices/src/recruitment-service/Infrastructure/Migrations/RecruitmentDbContextModelSnapshot.cs
  • microservices/src/recruitment-service/Infrastructure/Migrations
  • microservices/scripts/smoke-recruitment.ps1
  • microservices/src/recruitment-service/recruitment-service.csproj

See Also​

Keywords​

  • Recruitment database
  • Database Testing Guide

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-16
  • Review cycle: Quarterly