Get Around Database Locks with the NOLOCK Keyword

Using MBUnit's awesome Rollback attribute for unit tests cause the test to be wrapped in a transaction - which is well and good as that allows any changes made by the test to be undone. However, it also causes a database lock contention when you try to read from a locked row/table while debugging your unit test. Read on for a quick tip to get around this issue.