Skip to content
Jon P Smith edited this page Nov 21, 2023 · 18 revisions

Welcome to the EfCore.TestSupport wiki!

The NuGet package EfCore.TestSupport is a library containing methods to help you unit test applications that use Entity Framework Core for database access. The examples in this documentation uses xUnit, but these methods can be used with other unit test packages.

It has specific database code for:

  • SQL Server
  • PostgreSQL
  • Cosmos DB
  • Plus an in-memory database using SQLite (faster for simple EF Core databases)

List of versions and which .NET framework they support

  • Version 6.?.?: Supports NET 6, 7 and 8
  • Version 5.2.?: Supports NET 5, 6 and 7

There are older versions of the EfCore.TestSupport library, but .NET lower than .NET 5 are not supported by Microsoft.

NOTE: If you are looking for the EfSchemaCompare feature, it now has its own EfCore.SchemaCompare project/NuGet package.

The documentation topics are

This wiki defines the various groups and the signatures of the methods. The various groups of methods are listed below (see sidebar for links):

  • Helpers to create connection strings with a unique database name (via appsetting.json)
  • Methods to create EF Core databases
    • SQLite in-memory databases
    • SQL Server databases
    • Cosmos DB emulator databases
    • Add EF Core logging to any of the database types
  • Seed from Production feature
  • Various tools for getting test data, or file paths to test data
  • A tool for applying a SQL script file to a EF Core database
  • xUnit Fluent Validations.

This GitHub repository contains the source of the The NuGet package EfCore.TestSupport is the project TestSupport and various unit tests that check the project TestSupport.

What about older versions?

If are using the older versions of EF Core like that supports EF Core 2.1, 3, and 3.1, then you need EfCore.TestSupport, Version 3.2.0. The documentation for this older version can be found via the Version 3.2.0 docs link.

Clone this wiki locally