I'll apologize in advance for duplicating a reference off-site here but I posted a question on StackOverflow because I am having difficulty using NHibernate with the System.Data.SQLite provider and MbUnit's [Rollback] test attribute (which really just uses TransactionScope.)
http://stackoverflow.com/questions/691151/using-mbunit3s-rollback-for-unit-testing-nhibernate-interactions-with-sqlite
From my research, I'm under the impression that NHibernate doesn't have difficulty with TransactionScope and this is supported by the fact that the same test run with a SQL Server 2005 provider instead runs successfully.
Is there anyway to resolve or work around this issue or am I working against a SQLite limitation?