Ayende @ Rahien

Ayende Rahien commented on NHibernate Query Generator - More Collections Magic

Fri, 08 Jun 2007 16:18:04 GMT

AsbjornM , There are levels of use in each platform. What I am showing here is meant for those that are already familiar with NHibernate and wants to take advantage of their knowledge in the best possible way. For beginners ,there are numbers of avenues. There is a DNR TV episode that I did on NHibernate which may give you an idea about how to start, and there are numerous articles about it, including the book that you have mentioned. The sample code that I have shown is using Active Record, which does give you an implementation of FindAll, FindOne, etc. As for tools, you can check out Active Writer

AsbjornM commented on NHibernate Query Generator - More Collections Magic

Fri, 08 Jun 2007 14:45:43 GMT

I like the ideas you show here, but how can an n00b get started on this? I'm looking for starting points, and have tried the quickstart thingy for nhibernate so I have an class, mapping etc to get one row from an database. But my "User" object does not have any FindOne method.., and I'm looking through the generated QueryBuilder.cs but cannot find anything that refers to my class, even if I fed it with my dll and mapping file.. Everything I read around on this things looks like it is suited for people who have been using nhiber etc for many years.. When I took up subsonic, that was very easy, generating classes with foreignkey support and everything.. but it lacks some serious functionality imho, like joins, and therefore I want to check out nhiber, but it gives me pain. so I was hoping the querygenerator and stuff could ease that, but not yet.. I even bought the book NHibernate in action from Kuate, but that is not easily grasped... yet.. And doesn't it exist any tool that can read the database, generate mappinfiles, and classes to avoid some of the DRY principles? at least for getting started, like reverseenginering in visio etc..so you don't need to type everything 3-4 times?

Christian Crowhurst commented on NHibernate Query Generator - More Collections Magic

Thu, 07 Jun 2007 21:06:59 GMT

This was just what I was looking for when I emailed you recently asking whether NQG supports quering associations. Thank you very much! Christian

Ayende Rahien commented on NHibernate Query Generator - More Collections Magic

Thu, 07 Jun 2007 06:28:55 GMT

Can we continue this discussion at I would like to get a full test case, one that I can run.

AndyHItchman commented on NHibernate Query Generator - More Collections Magic

Thu, 07 Jun 2007 06:26:16 GMT

I love this syntax. I tried to use the new With() to FetchMode.Eager a collection, but no luck (it was lazy). See my test for what I am hoping would work... I took a look at the QueryBuilder and custom tool output and my head hurt, but what I was trying seemed to be within the realms of possibility. Any tips? ----------------------- public void TestTraverseOperationsWithPreemptiveFetch() { DataAdapter appDa = new DataAdapter(); Application application = null; using (UnitOfWork.Session) { // DetachedCriteria dc = DetachedCriteria.For(); // dc.Add(Expression.Eq("Id", new Guid("{DD635128-387B-46de-A850-F1F59FB4167F}"))) // .SetFetchMode("Operations", FetchMode.Eager); // application = appDa.FindOne(dc); application = appDa.FindOne( Where.Application.Id == new Guid("{DD635128-387B-46de-A850-F1F59FB4167F}") & Where.Application.Operations.With(FetchMode.Eager)); } Assert.IsNotNull(application); Assert.AreEqual(new Guid("{DD635128-387B-46de-A850-F1F59FB4167F}"), application.Id); Assert.AreEqual(1, application.Operations.Count); } -----------------------

MarcelloP commented on NHibernate Query Generator - More Collections Magic

Wed, 06 Jun 2007 14:18:14 GMT

Ok, with the latest version now it works! ;)

Jose commented on NHibernate Query Generator - More Collections Magic

Wed, 06 Jun 2007 11:16:40 GMT

Great job Ayende, but I think I have a problem. I'm using ActiveRecord, I have a class CentroRecolector wich have a collection of objects of type Instrumento, but NHQG does not generate the necesary code to be able to write Where.CentroRecolector.Instrumentos.With nor Where.CentroRecolector.Instrumentos.Exists

Ayende Rahien commented on NHibernate Query Generator - More Collections Magic

Wed, 06 Jun 2007 09:38:09 GMT

I should be replaced when you run the code, can you check it? Line #113, program.cs

MarcelloP commented on NHibernate Query Generator - More Collections Magic

Wed, 06 Jun 2007 09:23:20 GMT

I've found a little bug, the QueryBuilder.cs file is generated with the literal "namespace" attached to the generated namespace declaration: namespace QueryNamespace { public partial class QueryBuilder ..... .....

MarcelloP commented on NHibernate Query Generator - More Collections Magic

Wed, 06 Jun 2007 08:56:49 GMT

Wonderfull! Great Job Ayende!