HQL to SQL converter

Question

Does anyone know how to convert NHibernate HQL to SQL Scripts?

Answer 1

Since HQL translation depends on your mappings and also runtime behaviour, I think it is unlikely there is a way to do so statically.

You could run the HQL against a real database and capture the generated SQL either via a profiler for your specific rdbms or NHProf.

Answer 2

I asked basically same question about Hibernate's Java version.

Answer 3

I'm not familiar with all the parameters, but this seems to work:

ISessionFactory sessionFactory = ...
var sf = (SessionFactoryImpl) sessionFactory;
var hql = "from Person";
var qt = sf.Settings.QueryTranslatorFactory.CreateQueryTranslator("", hql, new Dictionary<string, IFilter>(), (ISessionFactoryImplementor) sessionFactory);
qt.Compile(new Dictionary<string, string>(), true);
var sql = qt.SQLString;
Console.WriteLine(sql);

Answer 4

I'm not sure what the value of auto-converting HQL to SQL is dynamically...

What exactly are you trying to accomplish by this?

The easiest way would be to run your code while running SQL Server Profiler to see the generated SQL. But a better approach would be to download nhProf (www.nhprof.com) and use that with your code. You will be able to see exactly what your code is outputting in SQL and it will format and color code it and also give you tips on ways to improve your usage of nhibernate.