How use Inner JOIN IN ORM2010

[kunal]

Hi

Following query  return me a list of record......

Select  ARM.ID,ARM.name from artist as A
INNER JOIN artist_role As AR ON AR.artist_id = A.id
INNER JOIN artist_role_master As ARM ON ARM.id = AR.artist_role_master_id

I want this Query in .net Using ORM2010

[Damyan Bogoev]

Hi kunal,

 The requested LINQ query should be defined in the following way:

var query =
    from artist in context.Artists
    join role in context.ArtistRoles on artist.Id equals role.ArtistId
    join master in context.ArtistRoleMaster on role.Id equals master.ArtistRoleMasterId
    select new { master.ID, master.Name };

Hope that helps.

Best wishes,
Damyan Bogoev
the Telerik team