A follow-up to an earlier post on streaming results from Entity Framework Core via Web API, this time showing how to move database access logic out of the API controller and into a service layer. The ProductsService encapsulates IQueryable-returning methods for streaming and non-streaming data retrieval, with AutoMapper used for projecting entities to view models. The post also briefly notes a discovered performance bug in EF Core 3.x to be covered in a future article.
