Linq query getting null value
Hi,i want to get RoleName by UserId using linq query. i am getting null value
These are IEnumerable collections.
this is my query :
string RoleName = (from Users in db.Users
join UserRoles in db.UsersInRoles on Users.UserId equals UserRoles.UserId
join roles in db.Roles on UserRoles.RoleId equals roles.RoleId
where Users.UserId == UserId
select roles.RoleName).SingleOrDefault();
can any one help me what is wrong this ?