Within ActiveRecordMediator, should use Execute or CreateSession?

Question

Suppose I'm going to do something that needs access to NHibernate's ISession. For example running a Sql query via ISQLQuery or running a LINQ-to-NHibernate via session.Linq<MyType>(). I know there is 2 way to access ISession:

1. ActiveRecordMediator.GetSessionFactoryHolder().CreateSession()
2. ActiveRecordMediator.Execute()

What is the pros and cons of each one? additionally is there another alternative ways?

Answer 1

I can't think of any technical reason to prefer one over the other, however ActiveRecordMediator.Execute is the documented way.

BTW you don't need any of this to do LINQ queries, you can use Castle.ActiveRecord.Linq instead.