title: Is there any easy way to convert Criteria to HQL?
body: <p>I have posted a <a href="https://stackoverflow.com/questions/534572/querying-on-collection-with-nhibernate-criteria-api">question</a> 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</p>
  
  <p>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.</p>
  
  <p>So my question is is there any tool or way to convert Criteria to HQL.</p>
  
  <p>or</p>
  
  <p>Is there any way to get Criteria and Hql work together?</p>
  
  <p><a href="http://derek-says.blogspot.com/2008/06/duplicate-association-path-bug-in.html" rel="nofollow noreferrer">An Article about the bug in nhibernate</a></p>