SQL join QUERY to Nhibernate icriteria conversion

Question

I am basically new to Nhibernate and I am facing problems in converting this query to NHibernate ICriteria interface:

SELECT Batch, 
       FkDegreeID,
       CourseTitle
  FROM JinnahCourseMapping
  JOIN JinnahCourse ON JinnahCourseMapping.FkCourseID = JinnahCourse.ID
 WHERE JinnahCourseMapping.FkDegreeID = 196608 
   AND JinnahCourseMapping.Batch = '2007';

I can't seem to find any solid answer to the problem, I'm hoping someone will be able to help me here :(

Is there a reason that you want to convert this to ICriteria and not HQL or LINQ? Which version of NHibernate are you using? — James Kovacs, Nov 24 '10 at 01:30

score 0 · Accepted Answer · edited May 23 '17 at 10:33

0

Your sql code seems to be quite straightforward. What kind of problem do you have? Here is a similar question that could help you: NHibernate - CreateCriteria vs CreateAlias.

edited May 23 '17 at 10:33

Community

1
1

answered Nov 24 '10 at 01:25

Denis Ivin

5,594
1
26
25

SQL join QUERY to Nhibernate icriteria conversion

1 Answers1