Tag Archives: C#

Manual ORM via ADO.Net when other platforms aren’t applicable

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 which these tools can be used, and this article is *not* an evaluation of them nor does it prescribe situations in which… Read more »

Using XML as an input parameter to stored procedures in favor of table-valued parameters

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…. Read more »

Supporting multiple environments through configuration

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 developers are forced to… Read more »