Hi,

I need some direction regarding the most appropriate way to query entities. Take the example below, I have TestEntityA and TestEntityB.
I want to retrieve all TestEntityA Where TestB.Code = 'test'

Would I have to create a Named Query to do this? Or can I utilise the ISession.CreateCriteria?

What is my best option to do this?
Thanks heaps.

public class TestEntityA
{
public TestEntityA() { }

public virtual Guid Id { get; set; }
public virtual string Name { get; set; }
public virtual TestEntityB TestB { get; set; }
public virtual byte[] Version { get; set; }
}

public class TestEntityB
{
public TestEntityB() { }

public virtual Guid Id { get; set; }
public virtual string Code { get; set; }
public virtual string Description { get; set; }
public virtual byte[] Version { get; set; }
}

You can use any of these:

- criteria
- HBM
- named query

You normally use criterias if your query is dynamic (e.g. the user can specifiy which properties to search on). For everything else HBM is the easier way. And the best way to use HBM is to put it into a named query. Then you can change the query by simply manipulating the mapping file without touching the code (at least as long as you still get the same type of resultset).

Thanks for the reply wolli.

How would the criteria query look like?

The following expression does not work
ICriterion cr1 = Expression.Sql("TestEntityB.Code = 'test'")

Thanks heaps.

Depends on the mapping. If TestEntityB is an association, something like this:



You should have a look at the docs:

http://nhforge.org/doc/nh/en/index.html#querycriteria