Thursday, August 9, 2012

Multiple Table's Join In LINQ

List<PM> ObjPermission = (
from P in Permissions
join RD in RoleDetails on P.PermissionID equals RD.PermissionId
join RM in RoleMasters on RD.RoleId equals RM.RoleID
where RM.RoleID == AgentId
select P).ToList();

No comments:

Post a Comment