-
The affect of latency on MSSQL INSERTs
SQL is a network application and according to The Fallacies of Distributed Computing tells us that in any network application latency is non-zero. In this article we will explore the effect of latency on SQL insert performance from the scenarios in my last post.…
-
MSSQL and large INSERT statements
There are several different ways of inserting data in MSSQL. In this post I explore several ways of inserting data and examine how they perform.…
-
Entity Framework Performance Cheat Sheet
Performance is important in our applications, this cheat sheet gives tips to improve the Big O performance of your Entity Framework applications and suggestions for when and what to optimise.…
-
Entity Framework - Navigation Property Basics with Code First
Navigation properties are Entity Frameworks way of representing Foreign Key relationships in databases as C# object references. In this post I explore the basics of how to use Navigation Properties with C# and how they work.…
-
EntityFramework Performance and AutoDetectChanges
Entity Framework change tracking performs well when using small sets of data however as the number of changes grows it becomes inefficient. In this post we look at what causes this degradation and how we can tune EF to perform better with large data sets.…
-
Making Dapper Faster with Transactions
Transactions are an often neglected component of how we access databases. They are important when we are writing to databases as they affect how and how often tables are locked. In this post we will examine what kind of difference transactions make in practice.…
-
Entity Framework and AsNoTracking
Entity Framework change tracking allows the framework to persist only changed data to the database, however this comes at a performance cost. This post discusses the performance impacts of change tracking and when its appropriate to switch it off.…
-
Entity Framework Comparative Performance
I have heard many claims that specific ORMs far outperform others, so I built my own ORM performance testing framework to test some of these results for myself. What I found is there is less difference in performance between ORMs than I expected.…
-
Using a REST WCF Service
WCF WebAPI allows REST support within WCF. This post discusses some of the gotchas of building REST services with WCF and provides a simple tutorial for creating a basic WCF REST service.…
-
StaticVoid Repository Pattern - GitHub
I've been wanting to have a play with GitHub for a while now given so many open source projects seem to be using it. So i finally gave it a go and pushed my Repository Pattern stuff to a public GitHub repository.…