C# Corner
Tech
News
Videos
Forums
Trainings
Books
Events
More
Interviews
Jobs
Live
Learn
Career
Members
Blogs
Challenges
Certifications
Bounties
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
LINQ JOIN Query Returning String Array
WhatsApp
Debasish Tutu
10y
7.1
k
0
1
25
Blog
Query:
string[] roles =( from usr
in
dataBaseEntities.Users
join uir
in
dataBaseEntities.UserInRoles
on usr.UserId equals uir.UserId
join rl
in
dataBaseEntities.Roles
on uir.RoleId equals rl.RoleId
where usr.UserId==user.UserId
select
new
{ rl.RoleName }). AsEnumerable().Select(x => string.Format(
"{0}"
, x.RoleName)).ToArray();
Output:
It will give all the roles assigned to the Particular user based on usedId.
People also reading
Membership not found