SQL join QUERY to Nhibernate icriteria conversion
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.FkDegreeI开发者_StackOverflowD = 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 :(
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.
精彩评论