Hi, I am working in a project, where the ISession is being binding in the ISessionFactory, so, I can access it using the sessionFactory.GetCurrentSession() method. In my scenario, the customer will config a sql query to be execute to get some value from the database. I use this value to persist another entity.
var session = _sessionFactory.GetCurrentSession(); var value = _session.CreateSQLQuery(sqlCustomer).List(); /* query execute fine and I get the result to persist another object */ _session.Save(entity); The problem is when I try to Save another object, I get an exception saying that the ExecuteReader cannot be executed because the connection is closed. If I remove the call of CreateSQLQuery, it works fine. Does anybody knows, how can I fix it to keep the connection open? Thank you. -- ______________________________________ Felipe B Oriani [email protected] -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
