Problem
~80 tests are marked inconclusive/skipped in CI because they require a live SQL Server at 127.0.0.1:1433. There are no integration tests against PostgreSQL, MySQL, or SQLite.
Current CI (PR #24) passes unit tests but cannot validate end-to-end CRUD/LINQ behavior against real databases.
Proposed solution
- Add Testcontainers for one or more providers in CI
- Categorize tests with
[TestCategory("Integration")] vs unit tests
- Run integration tests in a separate CI job (or nightly) with service containers
- Keep fast unit-only job for PR feedback
Suggested starting point:
- SQL Server container for existing DB-dependent tests
- SQLite in-memory or file-based container for lightweight multi-provider coverage
Acceptance criteria
Related
Complements #28 (unit test coverage). Reduces reliance on SkipIfDatabaseUnavailable() / Assert.Inconclusive.
Problem
~80 tests are marked inconclusive/skipped in CI because they require a live SQL Server at
127.0.0.1:1433. There are no integration tests against PostgreSQL, MySQL, or SQLite.Current CI (PR #24) passes unit tests but cannot validate end-to-end CRUD/LINQ behavior against real databases.
Proposed solution
[TestCategory("Integration")]vs unit testsSuggested starting point:
Acceptance criteria
Related
Complements #28 (unit test coverage). Reduces reliance on
SkipIfDatabaseUnavailable()/Assert.Inconclusive.