Tag Archives: SQL

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 »