Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
group_concat in LINQ
manjula d
11y
3.1k
1
Reply
("SELECT GROUP_CONCAT(RoleName) as RoleName FROM tbl_user_relationU JOIN tbl_role R ON R.role_id=U.RoleId WHERE U.user_id=9")
aboue query i want to change in LINQ
from U in objEntity.tbl_user_relation join R in objEntity.tbl_role on U.RoleId equals R.Role_Id where U.User_Id == 9 select new { RoleName = R.RoleName}).ToList().Select(x => new {RoleNames = string.Join(",", x.RoleName)});
i wrote the aboue query but not displaying group of RoleNames
please help me...
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Expression Tree
LINQ value.contains function error