Hindsight I wrote this article before I had heard of or come across the excellent Dapper library. Nowadays I highly recommend that. :) Sometimes you come across situations where it is inappropriate to use a higher-level ORM utility such as EntityFramework, NHibernate or others. There are many very good situations in …

Read More

I’ve been in the technology industry for many years and have finally gotten around to creating a blog. I had considered it before but what, you may ask, pushed me over the edge to actually creating one? Not only creating one, but shelling out some cash for my own domain rather than a freely hosted one? Well, it’s been …

Read More

A common challenge with stored procedures is how to pass in multiple rows to a single stored proc call — especially when you know all of the new / updated rows at a single time. Doing so can save on round trips as well as (sometimes) making transaction handling easier. Failed Attempt 1: Just use flat parameters If you …

Read More

Having some guiding principles (rules, if you will) that you follow when performing tasks can help you be more effective when doing those tasks. Here are some of the prgramming rules I follow. The SOLID principles are worth knowing as well.

1. Know and leverage your toolset Be aware of the framework(s) that you are …

Read More

Abstract Provide a technique for setting up configuration files that can support multiple environments (e.g. staging and production) and allow for central deployment without having to update config files on the fly during deployment. Benefits of the approach described: config files are not touched during deployment …

Read More