NPoco vs UkrGuru.Sql: When Streaming Beats Buffering - DEV Community

This page presents a performance benchmark comparing NPoco and UkrGuru.Sql libraries using BenchmarkDotNet for reading large tables from SQL Server in .NET. The article demonstrates that streaming rows with IAsyncEnumerable<T> is faster, allocates less memory, and scales better than buffering entire results into lists. The benchmark uses a realistic scenario with a Customers table containing CustomerId, FullName, Email, and CreatedAt columns, emphasizing that API design significantly impacts performance alongside implementation details.