Mocking dbset where method returns notSupportedException

Question

I'm trying to Mock the where clause of the dbset of my generic repository, and no idea why I'm getting a System.NotSupported Exception. I'm quite new into mocking, so I have no clue why this is happening.

private List<StubEntity> _data;
private Repository<StubEntity> _repository;

[TestInitialize]
public void TestInitialize()
{
    _data = new List<StubEntity>
    {
        new StubEntity {Id = 1, Name = "Entity 1"},
        ...
    };
    var queryableData = _data.AsQueryable();

    var mockDbSet = new Mock<DbSet<StubEntity>>();
    mockDbSet
        .Setup(m => m.Where(It.IsAny<Expression<Func<StubEntity, bool>>>()))
        .Returns<Expression<Func<StubEntity, bool>>>(p => queryableData.Where(p));

    var context = new Mock<StubContext>();
    context.Setup(x => x.DbEntities).Returns(mockDbSet.Object);
    context.Setup(x => x.Set<StubEntity>()).Returns(mockDbSet.Object);

    _repository = new Repository<StubEntity>(context.Object);
}

I'm only testing the where clause into a test

[TestMethod]
public void Find_ReturnsProperEntity()
{
    var entity = _repository.Find(s => s.Id == 1);
    ....
}

where the Find method just call the where clause of the context.

public IEnumerable<TEntity> Find(Expression<Func<TEntity, bool>> predicate)
{
    return Context.Set<TEntity>().Where(predicate);
}

have you seen this answer ? http://stackoverflow.com/questions/25960192/mocking-ef-dbcontext-with-moq — cecilphillip, Mar 21 '16 at 03:04

Nkosi · Answer 1 · 2017-07-24T09:52:31.517

Moq has issues with non-virtual members (methods/properties) and will throw exceptions when they are encountered.

eg:

System.NotSupportedException: System.NotSupportedException: Invalid setup on a non-virtual (overridable in VB) member: x => x.DbEntities.

The assumption here is that your StubContext looks something like this...

public class StubContext : DbContext {
    //...code removed for brevity

    public DbSet<StubEntity> DbEntities { get; set; }

    //...other code removed for brevity
}

...when it should be edited with a virtual property like...

public class StubContext : DbContext {
    //...code removed for brevity

    public virtual DbSet<StubEntity> DbEntities { get; set; }

    //...other code removed for brevity
}

Using the following utility classes

using Moq;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;

public static class MockDbSet {
    public static Mock<DbSet<T>> Create<T>(params T[] elements) where T : class {
        return elements.AsDbSetMock();
    }
}

public static class MockDbSetExtensions {
    public static Mock<DbSet<T>> AsDbSetMock<T>(this IEnumerable<T> list) where T : class {
        IQueryable<T> queryableList = list.AsQueryable();
        Mock<DbSet<T>> dbSetMock = new Mock<DbSet<T>>();
        dbSetMock.As<IQueryable<T>>().Setup(x => x.Provider).Returns(queryableList.Provider);
        dbSetMock.As<IQueryable<T>>().Setup(x => x.Expression).Returns(queryableList.Expression);
        dbSetMock.As<IQueryable<T>>().Setup(x => x.ElementType).Returns(queryableList.ElementType);
        dbSetMock.As<IQueryable<T>>().Setup(x => x.GetEnumerator()).Returns(() => queryableList.GetEnumerator());
        return dbSetMock;
    }
}

I recreated your unit test with a mocked DbSet and the suggested fix...

[TestClass]
public class MockDbSetTests {
    private List<StubEntity> _data;
    private Repository<StubEntity> _repository;

    [TestInitialize]
    public void TestInitialize() {
        _data = new List<StubEntity>
        {
            new StubEntity {Id = 1, Name = "Entity 1"},
            //...
        };

        var mockDbSet = _data.AsDbSetMock();

        var context = new Mock<StubContext>();
        context.Setup(x => x.DbEntities).Returns(mockDbSet.Object);
        context.Setup(x => x.Set<StubEntity>()).Returns(mockDbSet.Object);

        _repository = new Repository<StubEntity>(context.Object);
    }

    [TestMethod]
    public void Find_Should_Return_Proper_Entity() {
        //Act
        var entity = _repository.Find(s => s.Id == 1);
        //Assert
        Assert.IsNotNull(entity);
        Assert.IsTrue(entity.Count() == 1);
    }
}

...and it passed (GREEN).

I tried this using EntityFrameworkCore, but if my test includes a call to Where(), I'm getting a NullReferenceException calling Count on the result of that call: `Result StackTrace: at lambda_method(Closure , Value ) at System.Linq.Enumerable.WhereListIterator`1.GetCount(Boolean onlyIfCheap) at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source) at System.Linq.Queryable.Count[TSource](IQueryable`1 source)` Any idea on how to update this for Core? — Buddha Buddy, Jul 18 '18 at 01:28

Mocking dbset where method returns notSupportedException

1 Answers1