var permissions = from p in dc.Permissions
join ap in dc.AccountPermissions on
p.PermissionID equals ap.PermissionID
join a in dc.Accounts on
ap.AccountID equals a.AccountID
where a.AccountID == 1
select p;Should be:
var permissions = from p in dc.Permissions
join ap in dc.AccountPermissions on
p.PermissionID equals ap.PermissionID
join a in dc.Accounts on
ap.AccountID equals a.AccountID
where a.AccountID == AccountID
select p;Needed to amend LINE 06: the erroneous WHERE clause in the LINQ statement by replacing the literal '1' with the parameter reference 'AccountID'
No comments:
Post a Comment