Wonderfull! Great Job Ayende!

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<T>

.....

.....

I should be replaced when you run the code, can you check it?

Line #113, program.cs

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

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

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<Guid, Application> appDa = new DataAdapter<Guid, Application>();

        Application application = null;


        using (UnitOfWork.Session)

        {

// DetachedCriteria dc = DetachedCriteria.For<Application>();

// 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);

    }

This was just what I was looking for when I emailed you recently asking whether NQG supports quering associations.

Thank you very much!

Christian

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?