The provider for the source IQueryable doesn’t implement IAsyncQueryProvider

by

I get stuck on this issue today and this lib resolve it for me https://github.com/romantitov/MockQueryable completely, please refer:

Mocking Entity Framework Core operations such ToListAsync, FirstOrDefaultAsync etc.

//1 - create a List<T> with test items
var users = new List<UserEntity>()
{
  new UserEntity{LastName = "ExistLastName", DateOfBirth = DateTime.Parse("01/20/2012")},
  ...
};

//2 - build mock by extension
var mock = users.AsQueryable().BuildMock();

//3 - setup the mock as Queryable for Moq
_userRepository.Setup(x => x.GetQueryable()).Returns(mock.Object);

//3 - setup the mock as Queryable for NSubstitute
_userRepository.GetQueryable().Returns(mock);

More Related Contents:

  1. How are people unit testing with Entity Framework 6, should you bother?
  2. Recommended unit testing tool to test web services, api calls and sql calls [closed]
  3. Clone Enity framework POCO
  4. Dynamic LINQ OrderBy on IEnumerable / IQueryable
  5. Returning IEnumerable vs. IQueryable
  6. Mocking HttpClient in unit tests
  7. Use multiple JWT Bearer Authentication
  8. How can we run a test method with multiple parameters in MSTest?
  9. How do I use Assert to verify that an exception has been thrown?
  10. Compare equality between two objects in NUnit
  11. How to run unit tests (MSTest) in parallel?
  12. NUnit vs. Visual Studio 2008’s test projects for unit testing [closed]
  13. Mapping composite keys using EF code first
  14. What’s a good way to overwrite DateTime.Now during testing?
  15. Unable to create migrations after upgrading to ASP.NET Core 2.0
  16. Cannot resolve scoped service from root provider .Net Core 2
  17. Save detached entity in Entity Framework 6
  18. Mocking EF DbContext with Moq
  19. How to Compare two objects in unit test?
  20. How to add cookies to WebRequest?
  21. Integration test and hosting ASP.NET Core 6.0 without Startup class
  22. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  23. How can I catch UniqueKey Violation exceptions with EF6 and SQL Server?
  24. Unit test for thread safe-ness?
  25. How to mock Controller.User using moq
  26. Unit testing with EF Core and in memory database
  27. Creating recursive tree with AutoFixture
  28. How does the SQLite Entity Framework 6 provider handle Guids?
  29. AutoFixture fails to CreateAnonymous MVC Controller
  30. How to write this EF Mock setup code as a reusable Generic Boilerplate?

Leave a Comment