Monthly Archives: July 2012

ORM techniques for legacy databases

Posted on July 26, 2012 by Jimmy Bogard

One of the reasons folks typically go with a hand-rolled ORM (i.e., using ADO.NET by hand) is the assumption that ORMs don’t work well with legacy databases or databases designed in isolation from any sort of object model used to … Continue reading →

Posted in Architecture, NHibernate, SQL | 22 Comments

Don’t write your own ORM

Posted on July 24, 2012 by Jimmy Bogard

In my last post, I talked about various kinds of patterns of ORMs and how to choose an ORM strategy. From the comments and tweets I got, it seems like some folks still think that their only ORM choices are: … Continue reading →

Posted in Architecture | 35 Comments

Choosing an ORM strategy

Posted on July 20, 2012 by Jimmy Bogard

One of the mistakes I see people make (and have made myself) is assuming that you must choose exactly one ORM strategy for an entire database/application/system. It’s simply not the case. You can (and should) tailor your ORM strategy to … Continue reading →

Posted in Architecture | 32 Comments

Troubleshooting SQL index performance on varchar columns

Posted on July 18, 2012 by Jimmy Bogard

Doing a deployment last night, I ran into an issue around indexing performance around SQL columns of type varchar. Varchar is the ANSI version of character data – storing as 8-bits, while nvarchar is Unicode, storing as 16 bits. For … Continue reading →

Posted in Architecture | 12 Comments

Our Post-Agile World

Posted on July 10, 2012 by Jimmy Bogard

It’s been a looooong time since I’ve posted anything about Agile, and today I sat down to try and figure out why. It’s not that I don’t care about the values in the Agile Manifesto, nor that I’ve gone completely … Continue reading →

Posted in Agile | 7 Comments