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
Handing over my Baby eehmm Project
I’m just in the last phase of a project: Handing over my baby eehmm, sorry, I mean project to the maintenance team. Looking back, I find that the project has undergone a number of phases, setting quite different demands on the technical leadership. After this week I will no longer have any own assignments in… Continue reading Handing over my Baby eehmm Project
Lambda Closures Handle Event Handlers’ State
Subscribing to an event with a method that requires state is a pain because it often requires a class to be created to hold that state. Fortunately we can use a lambda expression to have the compiler create that state for us instead. It is not an uncommon scenario to have an event handler that… Continue reading Lambda Closures Handle Event Handlers’ State