Using NHibernate query to query NOT IN with JOIN statement -

Select HTML from the sample where there is no alphanumeric (sample from Sapler, choose selphanum, sampler sensignment, where sampler.lifanum = sampler.Signment. Alphanumeric

I want to use this statement and use the NHibernate query to execute it. How do I write to NHibernate?

Try:

  string hq = @ "saper s 1 Select from s1.alphanum where there is no s1.alphanum (s2.alphanum is selected from Sampler S2, SamplerSignment SA, where s2.alphanum = sa.alphanum and sa.isactive = 1) "; Var result = session.CreateQuery (hql). List ();  

Where sessions is your mission of NHiberNet.