I have this class ActivityTemplate that has a IList<Permission> as a property.

I have a query that I build in C#. Assume this is the query – sb is a string builder – the query works fine in DB

I have two unrelated entities in NHibernate which their ids are identical. The entities are known as Settlement and Transaction, and they are View in the DB. There are examples already with regards to how to join unrelated entities, and I used that as a guideline to try on the Views that I have. Example in the NHibernate doc.,