NHibernate Query Analyzer

NHQueryAnalyzer is a tool originally written by Ayende, and now it is supported at this link. I think that it is really a good tool, very useful even to learn HQL query because gives you an immediate idea of what the query will looks like. Here is a screenshot. (‘I’ve hide some sensitive part because this is part of a project of a company I worked with).

Untitled

  • Figure 1: A screenshot of Nhibernate Query Analyzer in action.*

Query parsing is instantaneous, so you can immediately understand if your query is good or wrong.

3

Figure 2: Query errors are immediately detected and signaled

You can also press F5 to execute the query to the database and take a look at returned object.

erwe

Figure 3: Result of query execution, you can look at returned objects and navigate to the object graph.

If you are a NHibernate user and you use HQL, you should not miss this tool.

Alk.

Tags: NHibernate HQL