The current documentation for Entity Framework suggests the usage of a real database.

The main reasons are:

• Launching a real database is currently very easy, using, for example, Docker containers.

• By using a local database, communication overhead is negligible.

• Mocked databases may not replicate properly the production database behavior, leading to tests that would fail if ran against the production database and to bugged logic.