Results 1 to 3 of 3

Thread: Using Inner Joins in nhibernate

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Unhappy Using Inner Joins in nhibernate

    How can we create a nHibernate criteria for the following query

    Code:
    Select UserID,UserName,Specification from tUser u innerjoin tUserType ut on u.UserTypeID=ut.UserTypeID where ut.UserType='Doctor' and u.UserName Like 'p%';
    Please help me out...

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: Using Inner Joins in nhibernate

    This is a data access issue and nothing to do with MVC so I have asked the mods to move it to the Database forum.

  3. #3
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,226

    Re: Using Inner Joins in nhibernate

    Quote Originally Posted by sanju4kk View Post
    How can we create a nHibernate criteria for the following query

    Code:
    Select UserID,UserName,Specification from tUser u innerjoin tUserType ut on u.UserTypeID=ut.UserTypeID where ut.UserType='Doctor' and u.UserName Like 'p%';
    Please help me out...
    Hibernate uses a different syntax for queries. Here's a page with some samples:

    http://hibernate-samples.blogspot.co...-examples.html
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width