What in-memory database providers are available for testing?

• EF Core InMemory provider: Lightweight, fast, but doesn’t mimic relational

database behavior exactly (no relational constraints, transactions).

• Other options: SQLite in-memory mode (better relational simulation).
• Use InMemory for unit tests; SQLite for more realistic integration testing.