开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜