This is a migrated thread and some comments may be shown as answers.

Why doesn't inner join work?

9 Answers 133 Views
LINQ (LINQ specific questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Alec
Top achievements
Rank 1
Alec asked on 29 Sep 2009, 07:31 AM
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.

 

9 Answers, 1 is accepted

Sort by
0
Alexander
Telerik team
answered on 29 Sep 2009, 12:46 PM
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.
0
Alec
Top achievements
Rank 1
answered on 29 Sep 2009, 02:00 PM
So...um.. is there something I can do? Or that means I cant use ORM at all...then...
0
Dimitar Kapitanov
Telerik team
answered on 02 Oct 2009, 06:42 AM
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.
0
Andi Keyes
Top achievements
Rank 1
answered on 06 Oct 2009, 09:51 PM
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.
0
Dimitar Kapitanov
Telerik team
answered on 07 Oct 2009, 08:38 AM
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.
0
Andi Keyes
Top achievements
Rank 1
answered on 07 Oct 2009, 03:11 PM
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.
0
Dimitar Kapitanov
Telerik team
answered on 09 Oct 2009, 08:14 AM
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.
0
Dallas Sehlhorst
Top achievements
Rank 1
answered on 14 Oct 2009, 01:58 PM
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?
0
Dimitar Kapitanov
Telerik team
answered on 14 Oct 2009, 02:49 PM
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.
Tags
LINQ (LINQ specific questions)
Asked by
Alec
Top achievements
Rank 1
Answers by
Alexander
Telerik team
Alec
Top achievements
Rank 1
Dimitar Kapitanov
Telerik team
Andi Keyes
Top achievements
Rank 1
Dallas Sehlhorst
Top achievements
Rank 1
Share this question
or