MockQueryable.Moq 10.0.5

.NET 10.0 This package targets .NET 10.0. The package is compatible with this framework or higher. 
dotnet add package MockQueryable.Moq --version 10.0.5
                    


                    

                
NuGet\Install-Package MockQueryable.Moq -Version 10.0.5
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="MockQueryable.Moq" Version="10.0.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="MockQueryable.Moq" Version="10.0.5" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="MockQueryable.Moq" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add MockQueryable.Moq --version 10.0.5
                    


                    

                
#r "nuget: MockQueryable.Moq, 10.0.5"
#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. 
#:package MockQueryable.Moq@10.0.5
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=MockQueryable.Moq&version=10.0.5
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=MockQueryable.Moq&version=10.0.5
                    


                            Install as a Cake Tool

MockQueryable

Extensions for mocking Entity Framework Core async queries like ToListAsync, FirstOrDefaultAsync, and more using popular mocking libraries such as Moq, NSubstitute, and FakeItEasy — all without hitting the database.

❤️ If you really like the tool, please 👉 Support the project or ☕ Buy me a coffee.

📦 NuGet Packages

Package Latest Version Install via Package Manager
Download Version Install-Package MockQueryable.Core
Download Version Install-Package MockQueryable.EntityFrameworkCore
Download Version Install-Package MockQueryable.Moq
Download Version Install-Package MockQueryable.NSubstitute
Download Version Install-Package MockQueryable.FakeItEasy

✅ Build & Status

codecov .NET Core License

⭐ GitHub Stats

Stars Contributors Last Commit Commit Activity Open Issues

💡 Why Use MockQueryable?

Avoid hitting the real database in unit tests when querying via IQueryable:

var query = _userRepository.GetQueryable();

await query.AnyAsync(x => ...);
await query.FirstOrDefaultAsync(x => ...);
await query.ToListAsync();
// etc.

🚀 Getting Started

1. Create Test Data

var users = new List<UserEntity>
{
    new UserEntity { LastName = "Smith", DateOfBirth = new DateTime(2012, 1, 20) },
    // More test data...
};

2. Build the Mock

var mock = users.BuildMock(); // for IQueryable

3. Set Up in Your favorite Mocking Framework

Moq
_userRepository.Setup(x => x.GetQueryable()).Returns(mock);
NSubstitute
_userRepository.GetQueryable().Returns(mock);
FakeItEasy
A.CallTo(() => userRepository.GetQueryable()).Returns(mock);

🗃️ Mocking DbSet<T>

var mockDbSet = users.BuildMockDbSet();

// Moq
var repo = new TestDbSetRepository(mockDbSet.Object);

// NSubstitute / FakeItEasy
var repo = new TestDbSetRepository(mockDbSet);

🔧 Adding Custom Logic

Example: Custom FindAsync

mock.Setup(x => x.FindAsync(userId)).ReturnsAsync((object[] ids) =>
{
    var id = (Guid)ids[0];
    return users.FirstOrDefault(x => x.Id == id);
});

Example: Custom Expression Visitor

Build a mock with the custom SampleLikeExpressionVisitor for testing EF.Functions.Like

var mockDbSet = users.BuildMockDbSet<UserEntity, SampleLikeExpressionVisitor>();

🧩 Extend for Other Frameworks

You can even create your own extensions. Check the example here.

🔍 Sample Project

See the sample project for working examples.

Product Compatible and additional computed target framework versions.
.NET net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (9)

Showing the top 5 NuGet packages that depend on MockQueryable.Moq:

Package Downloads
Zeesfam.NetLib

Package Description
Franz.Common.Testing

Shared utility library for the Franz Framework.
Simpository

A simple database repository library
VG.Infrastructure.EntityFramework.UnitTest

Package Description
TestAssist

Essential utilities and helpers for streamlined unit testing in C#

GitHub repositories (11)

Showing the top 11 popular GitHub repositories that depend on MockQueryable.Moq:

Repository Stars
simplcommerce/SimplCommerce
A simple, cross platform, modulith ecommerce system built on .NET
Ombi-app/Ombi
Want a Movie or TV Show on Plex/Emby/Jellyfin? Use Ombi!
VirtoCommerce/vc-platform
Virto Commerce B2B Innovation Platform
CodeMazeBlog/CodeMazeGuides
The main repository for all the Code Maze guides
lkurzyniec/netcore-boilerplate
Boilerplate of API in .NET 10
Librum-Reader/Librum-Server
The Librum server
carlreid/StreamMaster
A powerful M3U proxy and stream management platform for Plex DVR, Emby, Jellyfin Live TV (and more)
Letterbook/Letterbook
Sustainable federated social media built for open correspondence
SapiensAnatis/Dawnshard
Server emulator for Dragalia Lost
matt-bentley/CleanArchitecture
An opinionated ASP.NET Core solution setup for creating web applications using Clean Architecture and Domain-Driven Design principles.
microsoftgraph/group-membership-management
Group Membership Management (GMM) is a service that dynamically manages the membership of AAD Groups. Groups managed by GMM can have their membership defined using existing AAD Groups and/or custom membership sources.
Version Downloads Last Updated
10.0.5 39,856 3/15/2026
10.0.2 176,354 1/29/2026
10.0.1 203,327 11/22/2025
10.0.0 3,350 11/22/2025
9.0.0 287,514 10/6/2025
8.0.1 283,539 10/6/2025
8.0.0 423,852 7/27/2025
7.0.4-beta 131,918 9/24/2024
7.0.3 6,414,031 9/2/2024
7.0.2 217,001 8/20/2024
7.0.1 2,616,152 3/7/2024
7.0.0 4,585,039 11/21/2022
6.0.1 4,944,042 3/28/2022
6.0.0 246,883 3/24/2022
5.0.2 321,210 3/24/2022
5.0.1 2,755,945 5/25/2021
5.0.0 1,285,316 11/12/2020
5.0.0-preview.7 33,671 7/28/2020
3.1.3 2,333,917 5/19/2020
3.1.2 148,935 4/17/2020
Loading failed

#107 Microsoft.EntityFrameworkCore and Microsoft.EntityFrameworkCore.Relational v 10.0.5 - supported
 #113 AutoMapper to 16.1.1
 #105 FakeItEasy to 9.0.1