Tag Archives: ADO.Net

Using JSON to move beyond TVPs for multi-row updates

Many .NET applications will use Table-Valued-Parameters (TVPs) to send in a *set* of rows to be updated to a single stored procedure. Using this approach requires a decent amount of legwork to achieve: Define a “TYPE” in SQL Server to represent the table valued parameter Assign permissions to the TYPE… Read more »

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 »