Moq setup not returning expected object, mismatched invocation

Question

I have the following piece of code that I'm trying to mock out using Moq, specifically _userRepository.Find():

List<string> importEmails = ocrImportCentres.Select(c => c.CentreAdministratorEmail).Where(e => !string.IsNullOrWhiteSpace(e)).ToList();

 var existingUsersWithEmail =
            _userRepository.Find(
                x =>
                    importEmails.Contains(
                        x.PersonalDetailsHistory.OrderByDescending(h => h.DateCreated).FirstOrDefault().Email))
                .Select(o => new
                {
                    o.PersonalDetailsHistory.FirstOrDefault().Email,
                    (o as OCRInstitutionAdmin).UniqueId 
                });

The Find() methods are defined within IRepository:

IQueryable<T> Find(Expression<Func<T, bool>> predicate);
IQueryable<T> Find(Expression<Func<T, bool>> predicate = null, Func<IQueryable<T>, IOrderedQueryable<T>> orderBy = null, string includeProperties = "");

Moq setup within my unit test:

_userRepository.Setup(
            x =>
                x.Find(It.IsAny<Expression<Func<User, bool>>>(),
                    It.IsAny<Func<IQueryable<User>, IOrderedQueryable<User>>>(), It.IsAny<string>()))
            .Returns(existingAdmins.AsQueryable);

However when the unit test is ran _userRepository.Find() doesn't return the expected test object, after looking at the _userRepository.Verify(); I can see that my setup doesn't match the perform invocation and hence why I don't get my expected object returned.

Performed invocations:

IRepository`1. Find(x => value(OCRExamCreator.BusinessLogic.Services.OCRImportCentreManagementService+<>c__DisplayClasse).importEmails.Contains(x.PersonalDetailsHistory.OrderByDescending(h => h.DateCreated).FirstOrDefault().Email))

I did have the unit test passing and the Moq _userRepository.Setup working until I had to change the _userRepository.Find() LINQ to prevent the following exception:

{"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries."}

I have tried changing _userRepository.Setup() however I can't get it to return the test data I need, any help/pointers would be much appreciated

It looks to me like you are defining in Setup() to expect Find() with 4 parameters to be called, but Verify() is telling you that it was called with a single parameter, but that call to Find() is pretty hairy so I may be reading that wrong. — Sven Grosen
– Sven Grosen, Commented Dec 19, 2013 at 20:12
I did try setting up the Setup() using .Find() with a single parameter, e.g. mocking out IQueryable<T> Find(Expression<Func<T, bool>> predicate); however this resulted in a parameter count mismatch Exception which led me to use the other implementation of Find(). Thanks for looking. — Rocy
– Rocy, Commented Dec 19, 2013 at 20:55
As ledbutter pointed out the find method was being called with a single parameter. I don't really understand why this fixed the issue but I changed my setup to use a single parameter on the Find method but also overload the Returns method like so..._userRepository.Setup( x => x.Find(It.IsAny<Expression<Func<User, bool>>>())) .Returns((Expression<Func<User, bool>> predicate) => existingAdmins.AsQueryable()); This link helped me out stackoverflow.com/questions/5196669/… — Rocy
– Rocy, Commented Dec 23, 2013 at 16:41

2 revs · Accepted Answer · 2017-05-23 11:51:59Z

1

Fixed the issue by changing the setup() to use a single parameter on the Find method but also overloaded the Returns method like so...

_userRepository.Setup( x => x.Find(It.IsAny<Expression<Func<User, bool>>>())) 
               .Returns((Expression<Func<User, bool>> predicate) => 
                                                             existingAdmins.AsQueryable());

This link helped:

Moq'ing methods where Expression<Func<T, bool>> are passed in as parameters

edited May 23, 2017 at 11:51

community wiki

2 revs
forsvarir

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Moq setup not returning expected object, mismatched invocation

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related