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
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.
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.
Sincerely,
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.
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.
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.
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.