[question] What about `SelectMany`?

[igor-lukashenya]

Hi, I want to ask about SelectMany?

Are there any alternative or implementation for SelectMany?

[ffernandolima]

Hi!

For complex query operators like SelectMany a custom repository should be used instead.

There's an example here demonstrating how to create a custom repository and use all available features from DbSet and/or IQueryable.

The custom repository can be instantiated through IUnitOfWork which inherits from IRepositoryFactory, by accessing CustomRepository available method.

Example:

// Example: Custom Repository
var repository = _unitOfWork.CustomRepository<ICustomBlogRepository>();

var urls = await repository.GetAllBlogUrlsAsync()
      .ConfigureAwait(continueOnCapturedContext: false);

Also, the SelectMany official documentation can be found out here.