Mocking ISession.Query<T>() for testing consumer

Question

I'm trying to avoid using an in memory database for testing (though I might have to do this if the following is impossible). I'm using NHibernate 3.0 with LINQ. I'd like to be able to mock session.Query<T>() to return some dummy values but I can't since it's an extension method and these are pretty much impossible to test.

Does anyone have any suggestions (other than using an in memory database) for testing session queries with LINQ?

Answer 1

I've tried this before with previous versions of NH without much luck. I eventually used another class to wrap the query and mocked that instead.

I do think it's also worth writing an integration test against a real sql server, to make sure that the repository behaves as expected.