Loading

group_concat in LINQ

manjula d

13y9.2kLINQ

("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...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaganathan Bantheswaran13y ago
Accepted answer
Hi,

Try like this,

var names = string.Join(",", (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 R.RoleName).ToList());
manjula d13y ago
thanks jagan