利用ICriteria的NhiberNate的复杂查询会吗
select collum1 ,Collum2 from DataTable0
where (collum1 = 'a1' and Collum2 = 'b1') or (collum1 = 'a2' and Collum2 = 'b2')
哪位朋友可以帮忙将上面的sql语句用NHiberNate中的ICriteria表示出来吗,先多谢了
select Atable.collum1 ,BTable.Collum2
from DataTable0 Atable
inner join DataTable1 BTable on Atable.ID = BTable.PID
where Atable.collum1 = 'a1' and BTable.Collum2 = 'b1'
哪位朋友可以帮忙将上面的sql语句用NHiberNate中的ICriteria表示出来吗