Creates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Generates DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems. Use when creating integration tests for a migrated project, generating test coverage for data access layers, or writing Oracle-to-PostgreSQL migration validation tests.
This skill generates integration test cases for .NET data-access artifacts during Oracle-to-PostgreSQL database migrations. It produces database-agnostic xUnit tests backed by deterministic seed data so that the same tests validate behavior consistency whether they run against Oracle or PostgreSQL. The problem it addresses is migration risk: ensuring a data-access layer behaves identically on the new database, with Oracle treated as the golden source of expected behavior.
The workflow is a five-step checklist: discover the existing test project's conventions (base test class, seed manager, project file, inheritance and transaction patterns), identify testable data-access artifacts (repositories, DAOs, stored-procedure callers, query builders) scoped strictly to the target project, create minimal collision-safe seed data, write test cases, and review determinism. It emphasizes careful, non-destructive testing practices: avoid TRUNCATE TABLE, do not commit seed data because tests run in rolled-back transactions, reuse existing seed files, and preserve pre-existing business and lookup rows. Test-writing guidance stresses asserting logical outputs (rows, columns, counts, error types) rather than platform-specific error messages, asserting concrete expected values instead of mere non-null checks, covering empty-string and NULL inputs, and adding explicit timezone-sensitive assertions for timestamp handling. A final determinism review re-checks every assertion against seeded data.
Target users are .NET engineers and QA specialists executing Oracle-to-PostgreSQL migrations who need reliable cross-database validation coverage. Prerequisites are an already-scaffolded, compiling test project with established base-class and seed conventions. The skill is a single SKILL.md of test-authoring methodology; it is careful to preserve existing data and produces standard xUnit tests, with no destructive or external operations of its own.
Database-agnostic xUnit integration tests for .NET data-access artifacts, with deterministic seed data, designed to validate identical behavior on Oracle and PostgreSQL.
The test project must already exist and compile (scaffolded separately), and you should read the existing base test class and seed-manager conventions before writing tests.
It avoids TRUNCATE TABLE, does not commit seed data (tests run in transactions that roll back), adds only minimal collision-safe seed rows, and preserves existing business and lookup rows.
Assert logical outputs like rows, columns, counts, and error types rather than platform-specific messages, and assert concrete seeded values instead of just non-null or non-empty checks.
Tests capture Oracle's expected behavior and seed against Oracle, since the project is migrated to PostgreSQL later and must match Oracle's validated behavior.
Quick Setup:
.claude/skills/Repository
github/awesome-copilot