Loopback and kiss myself
A consequence of using transactions to rollback and thus cleanup after database dependent tests is that some code, which would not otherwise be run within a transaction context, doesn’t work when it is. One such situation is the case of a loopback server , which I’ve encountered several times over the years. when people stop being polite... and start getting real... The Real World A real world production environment might consist of several databases spread across several machines. And sometimes, as distasteful as it may sound, those databases are connected via linked servers. That is exactly the situation that we presently find ourselves in. We have quite a few views and procedures that make use of these linked servers, and those views and procedures invariably get called from within unit tests. That in of itself isn’t an issue for transactional unit tests. The critical factor is that our test environments, and more importantly our development environments aren’t spread acros