alkampfer on September 1st, 2010

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:

kick it on DotNetKicks.com

Tags:

4 Responses to “NHibernate Query Analyzer”

  1. Looks good but unfortunately at the moment there isn’t NH3 compatible version :(

  2. Actually I use a version modified by me that works with NH3 (I modified to work with 2.1.2 that uses the new HQL parser) if someone will like it I can post somewhere

    Alk.

  3. @Gian Maria

    That would be great if you could!

Trackbacks/Pingbacks

  1. Tweets that mention NHibernate Query Analyzer -- Topsy.com