To execute the db query itself asynchronously, you need to explicitly return either an IAsyncEnumerable<T>
or ActionResult<IAsyncEnumerable<T>>
from the controller.
See a bit more detailed explanation here: https://stackoverflow.com/a/78312071/9862613