Why doesn't inner join work?

10 posts, 0 answers
  1. Alec
    Alec avatar
    43 posts
    Member since:
    Mar 2009

    Posted 29 Sep 2009 Link to this post

    Why doesnt this work?

     

    var result = from g in scope.Extent<DODataClassGroup>()

     

     

        join c in scope.Extent<DODataClass>() on g.Id equals c.DODataClassGroup.Id

     

     

        join step in scope.Extent<DODataStep>() on c.Id equals step.DODataClass.Id

     

     

        join permission in scope.Extent<DOPermission>() on step.Id equals permission.DODataStep.Id

     

     

        join grouppermission in scope.Extent<DOGroupPermission>() on permission.Id equals grouppermission.Id

     

     

        join cmsgroup in scope.Extent<DOCMSGroup>() on grouppermission.Id equals cmsgroup.Id

     

     

        join cmsuser in scope.Extent<DOCMSUser>() on cmsgroup.Id equals cmsuser.Id

     

     

        where c.Active == true && g.Active == true && cmsuser.Id == intUserId

     

     

        orderby g.Order ascending

     

     

      select g;

    It keeps returning just 1 row.

     

  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 29 Sep 2009 Link to this post

    Hi Alec,

    Unfortunately Joins are not available in the current versions of Telerik OpenAccess ORM. However, they are implemented and will take part in our next release. We are sorry for the inconvenience caused.

    Regards,
    Alexander
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. DevCraft banner
  4. Alec
    Alec avatar
    43 posts
    Member since:
    Mar 2009

    Posted 29 Sep 2009 Link to this post

    So...um.. is there something I can do? Or that means I cant use ORM at all...then...
  5. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 02 Oct 2009 Link to this post

    Hi Alec,
    What we can do is prepare internal build that would be accessible through our site for download, and includes the joins functionality. This can be done later next week. Please tell me whether this works for you.

    Best wishes,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  6. Andi Keyes
    Andi Keyes avatar
    2 posts
    Member since:
    Jul 2009

    Posted 06 Oct 2009 Link to this post

    Is it possible for you to send me a link to this build as well?  I am running into a wall with a similar situation where I have to perform a join with another table to get the correct data.  Thank you.

    Sincerely,
    Amir Khawaja.
  7. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 07 Oct 2009 Link to this post

    Hi Amir Khawaja,
    You should be able to see it in your internal builds section when it is available. What I can do is to let you know when the build is available, is that OK?

    Sincerely yours,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  8. Andi Keyes
    Andi Keyes avatar
    2 posts
    Member since:
    Jul 2009

    Posted 07 Oct 2009 Link to this post

    Dimitar:

    Thank you for your prompt reply.  Ideally, I would really like access to the build today.  If that won't be possible then please do let me know when it does become available.  I do like the work Telerik is doing with Open Access but there just have been a few sore areas like JOINS that I believe are keeping the product from faster adoption.

    Sincerely,
    Amir Khawaja.
  9. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 09 Oct 2009 Link to this post

    Hello Amir Khawaja,
    We will be releasing the new internal build on Monday latest and I will update this thread asap when the build is available.

    Regards,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  10. Dallas Sehlhorst
    Dallas Sehlhorst avatar
    19 posts
    Member since:
    Feb 2006

    Posted 14 Oct 2009 Link to this post

    So I saw the latest Internal Build today- I noticed the version notes did not state that joins are supported.  Are they working with the latest release?
  11. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 14 Oct 2009 Link to this post

    Hello Dallas Sehlhorst,
    I was just about to update this thread: the build is available, and the join functionality is there (LINQ joins), I guess it is just missing from the release news. We are sorry about that.

    Greetings,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Back to Top
DevCraft banner