NHibernate QueryOver queries the db three times with the same query

Question

I ran into a strange issue with NHibernate today. I am pretty sure that there's an explanation and solution for this. So here we go: I have isolated one query with the issue and the code looks as follows:

_session = _sessionFactory.OpenSession();
ITransaction _transaction = _session.BeginTransaction();

var result = _session.QueryOver<Employee>()
   .Where(x => x.uid == employeeuid)
   .SingleOrDefault();

_transaction.Commit();

The Employee object has some references etc., but I don't think this is important right now. UID is a string. What basically happens is that log4net tells me that the same query is executed three times:

SELECT <some columns...> FROM employer this_ WHERE this_.uid = <uid-string>

As you can see... a plain query. Can anyone give me a hint how to get rid of the query-overhead?

Regards, Martin

Rippo · Accepted Answer · 2014-03-31 12:22:47Z

1

I would first back this up by seeing what is being queried on the database itself. To find out what the database is actualy doing either:-

Run SQL profiler and profile the queries
Download a trial version of NHProfiler and check on that. This is a great tool and well worth the money to purchase it if you find it helps for future issues.

Personally I am a little suspicious of the amount of log info that log4Net spews out.

answered Mar 31, 2014 at 12:22

Rippo

22.5k14 gold badges83 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Horvath Over a year ago

Lol, I didn't think of this possibility :-) Actually it was the case that logs were written multiple times. Thanks!

Collectives™ on Stack Overflow

NHibernate QueryOver queries the db three times with the same query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related