Map char values to enums using NHibernate Custom Types

Know your SQL optimization tricks

Cross Database SQL scripting

Have you ever found yourself in a situation where you had to write a stored procedure that needed to combine data from 2 different databases? Not that difficult, is it? But what if your procedure needs to be ‘generic’ so that it can run on different environments such as developing, testing and production where they all use different database names? I found myself in this situation today and I’d like to share my experiences here.