.NET Framework 4.8 v .NET 7 simple ADO.NET select performance benchmarks

I love it when an upgrade to the underlying .NET framework results in faster code without us actually having to change anything explicitly.

I found one example of this recently when I used BenchmarkDotNet to compare how long a simple ADO.NET select took using both .NET Framework 4.8 and .NET 7.

The results for the benchmarks which use Microsoft.Data.SqlClient (5.0.1) and select 1K and 100K records are below …

Click on the image for a larger view in a new window …


We can see .NET 7 is 23% and 33% faster than .NET Framework 4.8 when querying 1K and 100K records respectively.

While the absolute numbers are small these sort of ratio differences can make a big impact to many apps and show why it’s important to keep our apps running on the latest versions of .NET when we can.


You might also be interested in...

Entity Framework Tracking and AsNoTracking query performance comparison with benchmarks
I modified Microsofts sample Entity Framework benchmark class to just look at the relative timing differences of tracking versus non tracking … Continue reading Entity Framework Tracking and AsNoTracking query performance...

How to select specific columns in Entity Framework Core
When writing SQL queries we should avoid SELECT * if we don’t need all columns as it can have a … Continue reading How to select specific columns in Entity...

Entity Framework 7 bulk update performance benchmarks
Entity Framework 7 supports strongly typed bulk updates and deletes. This functionality is a nice addition as previously the built in way … Continue reading Entity Framework 7 bulk update performance benchmarks...

.NET 7 simple string concatenation benchmarks
Not too much change from .NET 6 string concatenation benchmarks I ran previously. String.Join still is the fastest while String … Continue reading .NET 7 simple string concatenation benchmarks...

.NET Framework 4.8 v .NET 7 reflection performance benchmarks
Just for fun I ran a BenchmarkDotNet comparison between .NET Framework 4.8 and .NET 7 for some reflection related functionality … Continue reading .NET Framework 4.8 v .NET 7 reflection...

Leave a Reply

Your email address will not be published. Required fields are marked *