NSubstitute DbSet / IQueryable

by

This happens because of NSubstitute syntax specific. For example in:

((IQueryable<Blog>) mockSet).Provider.Returns(data.Provider);

NSubstitute calls the Provider’s getter, then it specifies the return value. This getter call isn’t intercepted by the substitute and you get an exception. It happens because of explicit implementation of IQueryable.Provider property in DbQuery class.

You can explicitly create substitutes for multiple interfaces with NSub, and it creates a proxy which covers all specified interfaces. Then calls to the interfaces will be intercepted by the substitute.
Please use the following syntax:

// Create a substitute for DbSet and IQueryable types:
var mockSet = Substitute.For<DbSet<Blog>, IQueryable<Blog>>();
    
// And then as you do:
((IQueryable<Blog>) mockSet).Provider.Returns(data.Provider);
((IQueryable<Blog>) mockSet).Expression.Returns(data.Expression);
((IQueryable<Blog>) mockSet).ElementType.Returns(data.ElementType);
((IQueryable<Blog>) mockSet).GetEnumerator().Returns(data.GetEnumerator());

More Related Contents:

  1. Can you get the DbContext from a DbSet?
  2. One DbContext per web request… why?
  3. The entity type is not part of the model for the current context
  4. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  5. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  6. The operation cannot be completed because the DbContext has been disposed using MVC 4
  7. Configure multiple database Entity Framework 6
  8. DbContext discard changes without disposing
  9. How to Refresh DbContext
  10. summing values of a column based on id [closed]
  11. MSSQL Error ‘The underlying provider failed on Open’
  12. Why does the EF 6 tutorial use asynchronous calls?
  13. Method cannot be translated into a store expression
  14. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  15. One to one optional relationship using Entity Framework Fluent API
  16. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  17. Implementing Audit Log / Change History with MVC & Entity Framework
  18. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  19. Internal .NET Framework Data Provider error 1025
  20. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  21. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  22. get date part only from datetime value using entity framework
  23. Filtering include items in LINQ and Entity Framework [duplicate]
  24. ASP.NET Identity – Multiple object sets per type are not supported
  25. Entity Framework Code Only error: the model backing the context has changed since the database was created
  26. How are people unit testing with Entity Framework 6, should you bother?
  27. Update records using LINQ
  28. Duplicate key exception from Entity Framework?
  29. How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
  30. Change db table name in EF4 (entity framework 4)

Leave a Comment