Entity Framework Query for Complex Sql

Question

Anyone know how to represent this as an Entity Framework query? Either method syntax or query syntax is fine.

Declare @UserId int = 18

Select *
From [Profiles]
Where [Profiles].[ProfileId] 
IN( Select [SecurityProfileAssignments].[ProfileId]
    From [SecurityProfileUsers]
    Join [SecurityProfileAssignments] On [SecurityProfileAssignments].[SecurityProfileId] = [SecurityProfileUsers].[SecurityProfileId]
    Where [SecurityProfileUsers].[UserId] = @UserId)

Nick Vaccaro · Accepted Answer · 2014-07-17 19:49:17Z

1

Given a variable userId:

from p in Profiles
join spa in SeucrityProfileAssignments
    on p.ProfileId equals spa.ProfileId
join spu in SecurityProfileUsers
    on spa.SecurityProfileId equals spu.SecurityProfileId
where spu.UserId = userId
select new //optional object type
{
    //values to select
}

answered Jul 17, 2014 at 19:49

Nick Vaccaro

5,5126 gold badges42 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aBetterGamer Over a year ago

Awesome! Never thought to change the query! Works like a champ thanks!

Collectives™ on Stack Overflow

Entity Framework Query for Complex Sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related