Unit testing with EF Core and in memory database

by

It looks like you might want a class fixture.

When to use: when you want to create a single test context and share it among all the tests in the class, and have it cleaned up after all the tests in the class have finished.

Create a separate class to setup whatever data your tests will share, and to clean it up when the tests are finished running.

public class MovieSeedDataFixture : IDisposable
{
    public MovieDbContext MovieContext { get; private set; } = new MovieDbContext();

    public MovieSeedDataFixture()
    {
        MovieContext.Movies.Add(new Movie { Id = 1, Title = "Movie 1", YearOfRelease = 2018, Genre = "Action" });
        MovieContext.Movies.Add(new Movie { Id = 2, Title = "Movie 2", YearOfRelease = 2018, Genre = "Action" });
        MovieContext.Movies.Add(new Movie { Id = 3, Title = "Movie 3", YearOfRelease = 2019, Genre = "Action" });
        MovieContext.SaveChanges();
    }

    public void Dispose()
    {
        MovieContext.Dispose();
    }
}

Then use it in your tests by extending the IClassFixture<T> interface.

public class UnitTests : IClassFixture<MovieSeedDataFixture>
{
    MovieSeedDataFixture fixture;

    public UnitTests(MovieSeedDataFixture fixture)
    {
        this.fixture = fixture;
    }

    [Fact]
    public void TestOne()
    {
        // use fixture.MovieContext in your tests

    }
}

More Related Contents:

  1. How to write this EF Mock setup code as a reusable Generic Boilerplate?
  2. Mocking Extension Methods with Moq
  3. Mocking HttpClient in unit tests
  4. How to mock an async repository with Entity Framework Core
  5. Mocking Static Methods
  6. How to mock static methods in c# using MOQ framework?
  7. Mock static property with moq
  8. How to mock the new HttpClientFactory in .NET Core 2.1 using Moq
  9. Filter all queries (trying to achieve soft delete)
  10. Why am I getting an Exception with the message “Invalid setup on a non-virtual (overridable in VB) member…”?
  11. Using Moq to mock an asynchronous method for a unit test
  12. Is it possible to mock out a .NET HttpWebResponse?
  13. Using Moq to determine if a method is called
  14. Moq + Unit Testing – System.Reflection.TargetParameterCountException: Parameter count mismatch
  15. How to unit test with ILogger in ASP.NET Core
  16. How to mock ConfigurationManager.AppSettings with moq
  17. Mocking EF DbContext with Moq
  18. Why does the property I want to mock need to be virtual?
  19. How to test method call order with Moq
  20. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  21. Entity framework EF.Functions.Like vs string.Contains
  22. How are people unit testing with Entity Framework 6, should you bother?
  23. Moq – Non-overridable members may not be used in setup / verification expressions
  24. How do I mock User.Identity.GetUserId()?
  25. How do I Moq a method that has an optional argument in its signature without explicitly specifying it or using an overload?
  26. How to mock Controller.User using moq
  27. Cannot find command ‘dotnet ef’
  28. Using Moq to override virtual methods in the same class
  29. Mocking using Moq in c#
  30. How to (should I) mock DocumentClient for DocumentDb unit testing?

Leave a Comment