How to dynamically modify NHibernate load queries at runtime? EventListeners? Interceptors?

Question

I need to modify the query used to load many-to-one references in my model.

It needs to work with lazily loaded entities as well.

Specifically, I need to be able to further filter this data. Unfortunately, NH will not allow me to filter many-to-one relationships using the built in filtering system (?). I could just be doing something incorrect.

Is there a hook where I can manually and dynamically modify the query used to load the data? Or an alternative to filters that will allow me to specify parameters?

Background:

I am working with a database that is using a form of revision control, with each entity having a natural ID PK, an EntityId, a RevisionValidTo and RevisionValidFrom field. There may be many rows using the same EntityId, which is the reference for other tables to join on, but the Revision ranges are mutually exclusive. Thus, the relationship is only many-to-one IIF the filter is applied. However, NH offers no way to specify a filter on many-to-one references (they do for collections...)

Answer 1

I've been down this same road before I had the revelation that I don't have to lazy load my child objects. It may be worth the savings to just fill the entity from the repository when it is initially loaded. If you don't want to take the hit every time, you could put a little fluency on whatever you have interacting with the repository

GetObject(entityId).Including(x => x.Revisions).Between(...)