Null is an important, but sometimes hard concept. What’s the difference between an empty string and a null string? One of my first Stack Overflow questions was (NOT) NULL for NVARCHAR columns. Some people claim that using null is always wrong or is some kind of voodoo. If you feel the urge to use Nullable<int>… Continue reading On Null or Why Empty Strings are not Same as Null
Author: Anders Abel
The Project Saboteur’s Handbook
There are many ways to sabotage a project. Recognizing them is the first crucial step to counter them. In this brief handbook I will present a number of ways of sabotage that I have encountered in various projects. This post is the saboteur’s handbook. The countermeasures will be saved for another post. Enough of introduction.… Continue reading The Project Saboteur’s Handbook
Avoid broken Views in SQL Server with Schemabinding
Warning: WP_Syntax::substituteToken(): Argument #1 ($match) must be passed by reference, value given in /var/www/abel.nu/coding.abel.nu/wp-content/plugins/wp-syntax/wp-syntax.php on line 380
SQL Server views can get really weird when an underlying table is updated. I’ll show some examples and also the one must do for views to avoid problems. The broken views problem is something I discovered when working on a production system. When I first observed it I was shocked. When I dug deeper into… Continue reading Avoid broken Views in SQL Server with Schemabinding
How we Achieved the Best Code Quality in my Career
My recently finished project produced the best code quality in my career so far. The key success factors were a clear architecture, insane compiler warning levels and last but not least code reviews. The project was a greenfield project so there was no legacy code to inherit which gave us the opportunity to create something… Continue reading How we Achieved the Best Code Quality in my Career
EF Code First DbContext.SavingChanges
Unfortunately there is no SavingChanges event on the code first DbContext, but there is a way to get to it. The DbContext used for data access with Entity Framework Code First has a simplified API compared to the ObjectContext which is good. Unfortunately it is a bit too simple sometimes. For example there is no… Continue reading EF Code First DbContext.SavingChanges