Is there any easy way to convert Criteria to HQL?

.net asp.net nhibernate hql criteria
Barbaros Alp picture Barbaros Alp · Feb 12, 2009 · Viewed 7.6k times · Source

I have posted a question few days ago about Querying on collections with the Criteria API and after all the answers I see that the thing that I am trying is not possible with the Criteria, there is a bug for the situation in nhibernate and also in hibernate

I was using DetachedCriteria to get all criterias together and the list is really long. The last circle of chain is buggy criteria so I need to change all my detachedcriteria to HQL.

So my question is is there any tool or way to convert Criteria to HQL.

or

Is there any way to get Criteria and Hql work together?

An Article about the bug in nhibernate

Answer

jedierikb picture jedierikb · Feb 17, 2009

reposting from the hibernate forums... not sure if it is relevant to nhibernate or up to date

from: max Hibernate Team

Posted: Sun Dec 24, 2006 7:12 am

it is a very stubborn folklore that criteria translates to HQL. Criteria goes directly to SQL, but there is no direct public api to get it programmatically.

...

translating twice isn't very efficient ;)

http://forum.hibernate.org/viewtopic.php?t=968990&view=next&sid=50454aa6cec8d482198117fbd398ca70

Related questions

How to configure Fluent NHibernate to output queries to Trace or Debug instead of Console?

How to configure Fluent NHibernate to output queries to Trace or Debug instead of Console? I'm using MsSqlConfiguration.MsSql2008.ShowSql() but it has no parameters and I can't find anything on Google.

Read More
Fluent NHibernate Cascade Issue - Trying To Insert NULL ID

I have the following models & mappings (code snippets further below). One Competition has to have multiple CompetitionAnswers associated with it (multiple choice) from the outset. At present, using the Fluent NHibernate mappings shown below, when I create a brand …

Read More
In C#, what is the difference between public, private, protected, and having no access modifier?

All my college years I have been using public, and would like to know the difference between public, private, and protected? Also what does static do as opposed to having nothing?

Read More