NHibernate Query Generator with Visual Studio 2008
Posted
Monday, November 19, 2007 1:31 PM
by
cromwellryan
I've been using Ayende's NHibernate Query Generator (NHQG) to help type-ify my NHibernate repository queries. One of the great +1's of his tool is that you can apply it as a Custom Tool for your NHibernate mapping files right within Visual Studio.
With this setup, every change to my mapping file is reflected in my typed NHibernate ICriteria instances. For those who work directly with Hibernate Expressions, look how clean my queries are:
// Get it using the Id
public static MyClass GetById(long id)
{
return Repository.Get<MyClass>(Where.MyClass.Id == id);
}
// Get those updated today
public void Example2()
{
IList<MyClass> cards = Repository.Find<MyClass>(Where.MyClass.LastUpdated >= DateTime.Today);
}
That's just awesome!
There's a slight glitch though, his installer only registers the tool for Visual Studio 2005. I'm sure now that 2008 is RTM (I've been using Beta 2) he'll soon have a new version out, but in the mean time, you can use these two .reg files:
NHQG C# Custom Tool Registration
NHQG VB Custom Tool Registration