AsyncEnumerableReader Reached the Configured Maximum Size of the Buffer When Enumerating a Value

Have you ever encountered the error message “‘AsyncEnumerableReader’ reached the configured maximum size of the buffer when enumerating a value”? If so, you’re not alone. This error often occurs when using an async/await method that returns an IAsyncEnumerable<> to retrieve rows from a SQL Server database and provide them via a Web API in .NET…