C#•3y ago

❔ Unit test: The source 'IQueryable' doesn't implement 'IAsyncEnumerable<T>'

My test keep failing when it trying to get to this line of code

var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);

var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);

var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);

var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);

Detail

FindAll

IQueryable<T> FindAll(Expression<Func<T, bool>>? predicate = null);

IQueryable<T> FindAll(Expression<Func<T, bool>>? predicate = null);

IQueryable<T> FindAll(Expression<Func<T, bool>>? predicate = null);

IQueryable<T> FindAll(Expression<Func<T, bool>>? predicate = null);

Controller

    public async Task<IActionResult> GetAll(CancellationToken cancellationToken = default)
    {
        var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);
        return Ok(_mapper.Map<IEnumerable<FoodDTO>>(foods));
    }

    public async Task<IActionResult> GetAll(CancellationToken cancellationToken = default)
    {
        var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);
        return Ok(_mapper.Map<IEnumerable<FoodDTO>>(foods));
    }

    public async Task<IActionResult> GetAll(CancellationToken cancellationToken = default)
    {
        var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);
        return Ok(_mapper.Map<IEnumerable<FoodDTO>>(foods));
    }

    public async Task<IActionResult> GetAll(CancellationToken cancellationToken = default)
    {
        var foods = await _foodRepository.FindAll().ToListAsync(cancellationToken);
        return Ok(_mapper.Map<IEnumerable<FoodDTO>>(foods));
    }

Test

 public async Task FoodController_GetAll_ReturnOk()
    {
        #region[Arrange]
        var foods = A.Fake<IEnumerable<Food>>();
        var foodsDTO = A.Fake<IEnumerable<FoodDTO>>();
        A.CallTo(() => _mapper.Map<IEnumerable<FoodDTO>>(foods)).Returns(foodsDTO);
        var controller = new FoodController(_mapper, _foodRepository, _userFoodRepository);
        #endregion

        #region[Act]
        var result = await controller.GetAll();
        #endregion

        #region[Assert]
        result.Should().NotBeNull();
        result.Should().BeOfType(typeof(OkObjectResult));
        #endregion
    }

 public async Task FoodController_GetAll_ReturnOk()
    {
        #region[Arrange]
        var foods = A.Fake<IEnumerable<Food>>();
        var foodsDTO = A.Fake<IEnumerable<FoodDTO>>();
        A.CallTo(() => _mapper.Map<IEnumerable<FoodDTO>>(foods)).Returns(foodsDTO);
        var controller = new FoodController(_mapper, _foodRepository, _userFoodRepository);
        #endregion

        #region[Act]
        var result = await controller.GetAll();
        #endregion

        #region[Assert]
        result.Should().NotBeNull();
        result.Should().BeOfType(typeof(OkObjectResult));
        #endregion
    }

 public async Task FoodController_GetAll_ReturnOk()
    {
        #region[Arrange]
        var foods = A.Fake<IEnumerable<Food>>();
        var foodsDTO = A.Fake<IEnumerable<FoodDTO>>();
        A.CallTo(() => _mapper.Map<IEnumerable<FoodDTO>>(foods)).Returns(foodsDTO);
        var controller = new FoodController(_mapper, _foodRepository, _userFoodRepository);
        #endregion

        #region[Act]
        var result = await controller.GetAll();
        #endregion

        #region[Assert]
        result.Should().NotBeNull();
        result.Should().BeOfType(typeof(OkObjectResult));
        #endregion
    }

 public async Task FoodController_GetAll_ReturnOk()
    {
        #region[Arrange]
        var foods = A.Fake<IEnumerable<Food>>();
        var foodsDTO = A.Fake<IEnumerable<FoodDTO>>();
        A.CallTo(() => _mapper.Map<IEnumerable<FoodDTO>>(foods)).Returns(foodsDTO);
        var controller = new FoodController(_mapper, _foodRepository, _userFoodRepository);
        #endregion

        #region[Act]
        var result = await controller.GetAll();
        #endregion

        #region[Assert]
        result.Should().NotBeNull();
        result.Should().BeOfType(typeof(OkObjectResult));
        #endregion
    }

phaseshift•2/18/23, 1:33 PM

Iqueryable is ienumerable, not the async version

Pphaseshift Iqueryable is ienumerable, not the async version

TotechsStrypperOP•2/18/23, 1:46 PM

I still don't understand these type can you provide me a fix for this situation ?

phaseshift•2/18/23, 1:52 PM

Don't use ToListAsync

phaseshift•2/18/23, 1:52 PM

ToList() should work

phaseshift•2/18/23, 1:57 PM

Although ToList generally not a good idea to trigger on db queries

Pphaseshift ToList() should work

TotechsStrypperOP•2/18/23, 2:04 PM

I don't have permission to change the controller implementation right now do we have any alternative to make the unittest fit for this controller ?

phaseshift•2/18/23, 2:12 PM

Maybe you just need to add
using System. Data.Entity

TTotechsStrypper I don't have permission to change the controller implementation right now do we ...

PontiacGTX•2/18/23, 3:08 PM

what the repository implementation

PontiacGTX•2/18/23, 3:08 PM

probably it fails due to the query?

TotechsStrypperOP•2/18/23, 3:09 PM

TotechsStrypperOP•2/18/23, 3:09 PM

the mock is not implement the right interface

PontiacGTX•2/18/23, 3:09 PM

what is where if?

PontiacGTX•2/18/23, 3:11 PM

there showing you to send the predicate and would do it where isn't null

PontiacGTX•2/18/23, 3:11 PM

but you didnt send a predicate then it is null?

PontiacGTX•2/18/23, 3:11 PM

_foodRepository.FindAll()_foodRepository.FindAll()

PontiacGTX•2/18/23, 3:15 PM

so rather change the implementation for the FindAll repository's Method

Jayy•2/18/23, 3:24 PM

@TotechsStrypper use this https://github.com/romantitov/MockQueryable

GitHub

GitHub - romantitov/MockQueryable: Mocking Entity Framework Core op...

Mocking Entity Framework Core operations such ToListAsync, FirstOrDefaultAsync etc - GitHub - romantitov/MockQueryable: Mocking Entity Framework Core operations such ToListAsync, FirstOrDefaultAsyn...

Pphaseshift Don't use ToListAsync

Jayy•2/18/23, 3:24 PM

???

Jayy•2/18/23, 3:25 PM

Good lord y'all lol

Jayy•2/18/23, 3:26 PM

You have to mock async stuff a little diff

TotechsStrypperOP•2/18/23, 4:22 PM

So it cannot face the IQueryable
a guy help me create a custom interface
var foods = A.Fake<IEFMock>();

public interface IEFMock : IQueryable<Food>, IAsyncEnumerable<Food>
{
}

public interface IEFMock : IQueryable<Food>, IAsyncEnumerable<Food>
{
}

TTotechsStrypper So it cannot face the IQueryable a guy help me create a custom interface var fo...

Jayy•2/18/23, 5:26 PM

This will crash at runtime

Jayy•2/18/23, 5:26 PM

You have to mock all of IAsyncEnumerable

Jayy•2/18/23, 5:26 PM

Which the nuget i linked above does

Jayy•2/18/23, 5:26 PM

I've done this many times, it's an easy fix

TotechsStrypperOP•2/18/23, 5:26 PM

Do you know how to do that with my current test ?
I am a complete noob in FakeItEasy

TTotechsStrypper Do you know how to do that with my current test ? I am a complete noob in FakeI...

Jayy•2/18/23, 5:27 PM

Read the readme of the repo i just sent lol

TotechsStrypperOP•2/18/23, 5:28 PM

TotechsStrypperOP•2/18/23, 5:28 PM

wait

TTotechsStrypper Click to see attachment

Jayy•2/18/23, 5:28 PM

No lol, the library already handles all that for you

Jayy•2/18/23, 5:29 PM

Just read the docs and install the fake it easy version of the lib

TotechsStrypperOP•2/18/23, 5:29 PM

Jayy•2/18/23, 5:29 PM

There ya go

Accord•2/19/23, 5:42 PM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

❔ Unit test: The source 'IQueryable' doesn't implement 'IAsyncEnumerable<T>'

Similar Threads

Similar Threads

Similar Threads