Hi,
I have a site that use many native SQL queries like the following:
DAO.GetMyList() { string sql = "select dto_columns from tablea"; IQuery query = Session.CreateSQLQuery(sql).SetResultTransformer(Transformers.AliasToBean<InspectionDTO>()); return query.List<dto>(); }
When I run this site in my developement environment which is 32 bits developement IIS in VS 2010, everything is fine. However, when I deploy this to a IIS 7.5 site 64bits ASP.NET 4.0, connections are never return to pool.
Btw, I am using Session Per Request pattern to manage NHibernate sessions.
Is this a known issue? or did I miss any necessary code? or should I upgrade to NHibernate 3.1?
Thanks for any possible help!
HZ
|