Azure Load Testing is a fully managed load testing service that uses JMeter under the hood. It’s really easy to … Continue reading How to load test an App Service instance with Azure Load Testing
eShopOnWeb architecture article series (16 parts)
For learning and discussion purposes I’ve done up a series of short articles looking at the architecture of eShopOnWeb which … Continue reading eShopOnWeb architecture article series (16 parts)
Entity Framework DbContext pooling performance benchmark
Although creating DbContext objects is really inexpensive, in really high performance scenarios it may be beneficial to switch to using … Continue reading Entity Framework DbContext pooling performance benchmark
Change schema name in Entity Framework Core
When creating objects in the DB Entity Framework will use the default schema of the database (usually dbo) by default. … Continue reading Change schema name in Entity Framework Core
How to have multiple baselines in BenchmarkDotNet
Without doing anything else if we try to mark two or more benchmark methods as baselines BenchmarkDotNet will complain… .. … Continue reading How to have multiple baselines in BenchmarkDotNet
Group benchmarks by method when using Params in BenchmarkDotNet
Using the Params attribute in BenchmarkDotNet is really useful as it allows us to get benchmark results for each combination … Continue reading Group benchmarks by method when using Params in BenchmarkDotNet
How to have a GlobalSetup per benchmark in BenchmarkDotNet
If we are using BenchmarkDotNet and want to have a different setup method for each benchmark or groups of benchmarks … Continue reading How to have a GlobalSetup per benchmark in BenchmarkDotNet
How to configure inheritance mappings in Entity Framework 7
Table Per Concrete type is new in Entity Framework 7. Using TPC or existing inheritance mapping approaches supported in Entity … Continue reading How to configure inheritance mappings in Entity Framework 7
Entity Framework 7 TPH, TPT and TPC inheritance mapping performance benchmarks
Entity Framework 7 will support Table-per-Concrete (TPC) type inheritance mapping as introduced in this blog post on devblogs.microsoft.com. This is … Continue reading Entity Framework 7 TPH, TPT and TPC inheritance mapping performance benchmarks
How to view Cyclomatic Complexity in Visual Studio
Cyclomatic complexity is a measure of the distinct paths in a method. It can be useful for getting an idea … Continue reading How to view Cyclomatic Complexity in Visual Studio
Include only slow queries in a SQL Server Profiler trace
SQL Server Profiler is super useful for seeing what queries are going across the wire from your app to your … Continue reading Include only slow queries in a SQL Server Profiler trace
View transaction related events in a SQL Server Profiler trace
When we open SQL Server Profiler to start a new trace transaction related events are not visible by default in … Continue reading View transaction related events in a SQL Server Profiler trace
.NET 6 v .NET 7 reflection performance benchmarks
.NET 7 (Preview 5+) has some awesome performance improvements when it comes to reflection functionality like invoking methods BUT there … Continue reading .NET 6 v .NET 7 reflection performance benchmarks
Benchmark different batch sizes in Entity Framework using BenchmarkDotNet
The default batch size in Entity Framework is 42 but it’s good to try different variations of this to see … Continue reading Benchmark different batch sizes in Entity Framework using BenchmarkDotNet
Programmatically set Entity Framework batch size
The default batch size in Entity Framework is 42. This may be ideal in some cases but for others you … Continue reading Programmatically set Entity Framework batch size
How to use HILO with Entity Framework Core
In Entity Framework Identity DB server generated keys are most popular but as a latency optimization technique HILO keys can … Continue reading How to use HILO with Entity Framework Core
How to benchmark different versions of the same library with BenchmarkDotNet
If you want to benchmark the performance of two or more versions of the same library against each other you … Continue reading How to benchmark different versions of the same library with BenchmarkDotNet
Entity Framework 7 performance improvements due to less roundtrips
Entity Framework 7 Preview 6 has just been released (12th July 2022). Shay from the Entity Framework team has done … Continue reading Entity Framework 7 performance improvements due to less roundtrips
Entity Framework entity configuration with Fluent API
If you’re using the Code First approach in Entity Framework accepting the default mappings can result in an inefficient DB … Continue reading Entity Framework entity configuration with Fluent API
Showing TSQL preview in SQL Server Management Studio vertical scrollbar
When we are looking a stored procedures, views, functions etc. which have a lot of code in them it can … Continue reading Showing TSQL preview in SQL Server Management Studio vertical scrollbar
Drag object names from Object Explorer into query window in SQL Server Management Studio
To save you typing it’s possible to drag the names of objects such as Tables, Views etc. from the SQL … Continue reading Drag object names from Object Explorer into query window in SQL Server Management Studio
Running BenchmarkDotNet benchmarks against .NET 7
.NET 7 will be released in November 2022. If you want to run performance benchmarks against it using BenchmarkDotNet you … Continue reading Running BenchmarkDotNet benchmarks against .NET 7
Poll Results : Which Entity Framework workflow do you prefer, Code First or DB First?
I personally prefer the Database First approach but I was curious what Entity Framework workflow approach was most popular with … Continue reading Poll Results : Which Entity Framework workflow do you prefer, Code First or DB First?
How to turn off and disable Global Usings in Visual Studio
Not everyone is a fan of Global Usings which were released with C# 10 in November 2021. Since the templates … Continue reading How to turn off and disable Global Usings in Visual Studio
How to run benchmarks against multiple versions of .NET with BenchmarkDotNet
If you’re into this sort of stuff like me it can be fun to run benchmarks against bits of code … Continue reading How to run benchmarks against multiple versions of .NET with BenchmarkDotNet
Regular Expressions using RegexOptions.IgnoreCase slower than inline case insensitive pattern syntax in .NET 6
RegexOptions.IgnoreCase often offers better readability and expression of intent than inline pattern matching. We can see examples of the two … Continue reading Regular Expressions using RegexOptions.IgnoreCase slower than inline case insensitive pattern syntax in .NET 6
Three examples of Regular Expression performance improvements in .NET 7
Stephens Toubs performance articles on devblogs.microsoft.com are always something I look forward to. In May 2022 he wrote one covering … Continue reading Three examples of Regular Expression performance improvements in .NET 7