I have spent literally hours today Googling for even basic query
examples for Castle ActiveRecord, and have frustratingly come-up with
nothing. The VERY basic basics, like simple FindAll(), finding a
single record by its key, and all that, is quite simple. But it seems
once I'm a single step beyond that, I'm getting absolutely nowhere.

So with that, I have two questions:

1. Is there a good web resource that shows a range of common query
scenarios and how they're coded, since the documentation doesn't seem
to cover the subject?  (And neither, it seems, is there much coverage
of ICriterion[] from the NHibernate side.)

2. In particular, how to do you use ICriterion-based queries to filter
by values in a table joined with BelongsTo? I have a domain object of
Subscriber with a BelongsTo property pointing to a SubscriberType
object. I want to FindAll( ) the subscribers of a particular
SubscriberType, but this construct doesn't work:

                criterion = new ICriterion[] {
                    Expression.Eq("SubscriberType.Description",
"Fitness")
                };
                subscriberList = Subscriber.FindAll(order, criterion);

(Note that "order" is defined separately, elsewhere.)

That comes back with a runtime error of, "could not resolve property:
SubscriberType.Description of: Subscriber"

I've got to be missing something pretty simple, but all my Googling
is, as I said, returning nothing useful.

Thanks for any direction anyone can provide on this.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to