Using a Join Directly is currently not supported

[Hessner]

Hi,

I am moving my last LINQ2SQL source bits to OpenAccess, can you "fix" my join problem?

var query = (from u in Os.Extent<ORM.User>()
             join u1 in Os.Extent<ORM.UserRole>().Where(wherePart) on u.UserID equals u1.UserID
             join r in Os.Extent<ORM.Role>().Where(roles) on u1.RoleID equals r.RoleID
             orderby u.FuldeNavn.ToLower()
             select new
               {
               id = u.UserID,
               u.Email,
               Navn = u.FuldeNavn,
               Rolle = r.Beskrivelse
               }).Distinct();

I got the "Using a Join Directly is currently not support" on the first join.

Regards,
Bo Hessner

[Thomas]

Hello Bo,

we will provide support for joins in the near future, this feature is important for you and us!

In the mean time you might want consider using an object reference if that is possible for you.
I think in your example the UserRole class could have a User reference and a Role reference.
The query would then be for the moment:

var query1 = (from ur in Os.Extent<ORM.UserRole>() 
               select new
               { 
                 id = ur.User.UserID, 
                 email = ur.User.Email, 
                 Navn = ur.User.FuldeNavn, 
                 Rolle = ur.Role.Beskrivelse 
               }).Distinct().ToList();
var ordered = (from q in query1 orderby Navn.ToLower() select q);

Sincerely yours,
Thomas
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Hessner]

Thanks for the suggested solution - can we expect "Join" in Q2-2009?

[Peter Brunner]

Hi Bo,

we will work on it right after Q2 for which we have freezed code already. So please expect it soon after.

Greetings,
Peter Brunner
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Hessner]

Any news on this?

[Dimitar Kapitanov]

Hello Hessner,
We are working on that right now. When we have it in the product we will notify you.

Best wishes,
Dimitar Kapitanov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[richardFlow]

Did this get fixed in Q3 yet?

Richard

[PetarP]

Hello Web Belief Ltd,

Yes, the Q3 release contains join support for LINQ. You could find some join samples in the Linq Examples application distributed with the product.

All the best,
Petar
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.