.NET 6.0
dotnet add package Moq.EntityFrameworkCore --version
NuGet\Install-Package Moq.EntityFrameworkCore -Version
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Moq.EntityFrameworkCore" Version="" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Moq.EntityFrameworkCore --version
#r "nuget: Moq.EntityFrameworkCore,"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Moq.EntityFrameworkCore as a Cake Addin
#addin nuget:?package=Moq.EntityFrameworkCore&version=

// Install Moq.EntityFrameworkCore as a Cake Tool
#tool nuget:?package=Moq.EntityFrameworkCore&version=


Build Status Downloads

This library helps you mocking EntityFramework contexts. Now you will be able to test methods that are using DbSet<TEntity> or DbQuery<TEntity> from DbContext in an effective way.

Installation - NuGet Packages

Install-Package Moq.EntityFrameworkCore


For example we can assume that we have the following production code:

public class UsersContext : DbContext
    public virtual DbSet<User> Users { get; set; }

To mock Users and Roles you only need to implement the following 3 steps:

1. Create DbContext mock:

var userContextMock = new Mock<UsersContext>();

2. Generate your entities:

IList<User> users = ...;

3. Setup DbSet or DbQuery property:

userContextMock.Setup(x => x.Users).ReturnsDbSet(users);


userContextMock.SetupGet(x => x.Users).ReturnsDbSet(users);


userContextMock.SetupSequence(x => x.Set<User>())
  .ReturnsDbSet(new List<User>())

And this is all. You can use your DbContext in your tests.

The second option is mocking DbSet that is part of the interface:

public interface IBlogContext
   DbSet<Post> Posts { get; }

And then use:

var posts = new List<Post>();
var contextMock = new Mock<IBlogContext>();
contextMock.Setup(p => p.Posts).ReturnsDbSet(posts);

You will find examples of this library in the repository.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (3)

Showing the top 3 NuGet packages that depend on Moq.EntityFrameworkCore:

Package Downloads

Package Description


Devocean.Tests is a set of base classes and helpers inteded to support implementing integration and unit tests on projects based on Devocean.Core


Package Description

GitHub repositories (2)

Showing the top 2 popular GitHub repositories that depend on Moq.EntityFrameworkCore:

Repository Stars
The main repository for all the Code Maze guides
A sample app for my online course "Clean Architecture: Patterns, Practices, and Principles" in .NET Core
Version Downloads Last updated 988,143 12/1/2022 1,142,956 5/29/2022 58,457 5/29/2022 397,273 1/25/2022 12,191 1/25/2022 498,589 3/12/2021 100,253 11/29/2020 262,503 11/29/2020 160,028 6/29/2020 76,838 2/26/2020 39,196 11/9/2019 8,437 10/6/2019 116,283 6/30/2020
2.2.1 157,134 2/1/2019
2.0.1 190,765 2/23/2018
1.0.0 7,157 10/13/2017

Added support for EntityFrameworkCore 7.0