Scaffolds an xUnit integration test project targeting Oracle in .NET solutions. Creates the test project, transaction-rollback base class, and seed data manager. Use only during Phase 3, before writing Oracle baseline integration tests. Do not invoke during Phase 6 — the PostgreSQL test project is produced by migrating this project, not by running this skill again.
Start a fresh conversation. Replace the highlighted placeholders.
Use scaffolding-oracle-to-postgres-migration-test-project during Phase 3 to scaffold an empty Oracle xUnit integration-test project for [target .csproj] using [Oracle connection settings]; preserve existing .NET/C# versions, build it with zero errors before finishing, then wait for my integration choice.
Required inputs
[target .csproj]
[Oracle connection settings]
User-approved starter prompt based on a pinned source version; check current skill requirements before running. Task evidence ↗
SKILL.md
name: scaffolding-oracle-to-postgres-migration-test-projectdescription: 'Scaffolds an xUnit integration test project targeting Oracle in .NET solutions. Creates the test project, transaction-rollback base class, and seed data manager. Use only during Phase 3, before writing Oracle baseline integration tests. Do not invoke during Phase 6 — the PostgreSQL test project is produced by migrating this project, not by running this skill again.'
Scaffolding an Integration Test Project for Oracle-to-PostgreSQL Migration
Creates a compilable, empty xUnit test project with transaction management and seed data infrastructure for a single target project. Run once per project before writing tests.
Workflow
Progress:
- [ ] Step 1: Inspect the target project
- [ ] Step 2: Create the xUnit test project
- [ ] Step 3: Implement transaction-rollback base class
- [ ] Step 4: Implement seed data manager
- [ ] Step 5: Verify the project compiles
Step 1: Inspect the target project
Read the target project's .csproj to determine the .NET version and existing package references. Match these versions exactly — do not upgrade.
Step 2: Create the xUnit test project
Target the same .NET version as the application under test.
Add NuGet packages for Oracle database connectivity (Oracle.ManagedDataAccess.Core) and xUnit.
Add a project reference to the target project only — no other application projects.
Add an appsettings.json configured for Oracle database connectivity.
Step 3: Implement transaction-rollback base class
Create a base test class that opens a transaction before each test and rolls it back after.
Catch and handle all exceptions to guarantee rollback.
Make the pattern inheritable by all downstream test classes.
Step 4: Implement seed data manager
Create a global seed manager for loading test data within the transaction scope.
Do not commit seed data — transactions roll back after each test.
Do not use TRUNCATE TABLE — preserve existing database data.
Establish a naming convention for seed file location that downstream test creation will follow.
Step 5: Verify the project compiles
Build the test project and confirm it compiles with zero errors before finishing.
Key Constraints
Phase 3 only — this skill scaffolds the Oracle-targeting test project. The PostgreSQL test project (Phase 6) is created by copying and migrating this project; do not run this skill again at that point.
Oracle is the golden behavior source — scaffold for Oracle only, not PostgreSQL.
Keep to existing .NET and C# versions; do not introduce newer language or runtime features.
Output is an empty test project with infrastructure only — no test cases.