I'm targeting NHibernate 3.1. I'm working with a 3rd party database which I must treat as read-only. I'd like to query it as follows:
select distinct A.Code, A.Description, A.Category, O.Int_Option as IntOption from AML A left join OPT O on A.Supplier = O.Supplier where O.Int_Option = 'Y'
My first thought was to create a typedlist but there is no PK, FK relationship between AMT and OPT and it doesn't seem possible in the designer.
Is there another way? Am I approaching the problem incorrectly?
Cheers
Pete