Convert session.Find to session.CreateSQLQuery

Jorgen · **Posted:** Wed Jan 04, 2006 9:36 am

I want to convert

Code:

 session.Find(txn, "from t in class NHibernate.TopicDataObject where " + "  t.ObjectId = ? and t.TopicMap = ?", new Object[]{id, tmdo}, new IType[]{NHibernateUtil.String, NHibernateUtil.Entity(typeof(TopicMapDataObject))})

to

Code:

session.CreateSQLQuery(..?..)

I want to do this so that I can cache the query. What is the best way to convert this?

sergey · **Posted:** Wed Jan 04, 2006 10:21 am

You don't need to use SQL to make the query cacheable, just use session.CreateQuery("<your HQL here>").SetCacheable(true);

Jorgen · **Posted:** Wed Jan 04, 2006 11:56 am

It's the HQL syntaxs that I'm wondering about. How can I translate the one inside the Find(..) to a HQL for the CreateQuery()?

sergey · **Posted:** Wed Jan 04, 2006 4:12 pm

Jorgen wrote:

It's the HQL syntaxs that I'm wondering about. How can I translate the one inside the Find(..) to a HQL for the CreateQuery()?

CreateQuery uses HQL, you don't need to translate anything.