Monday 13 June 2011

ASP.Net 3.5 Social Networking - ERRATA

This code:

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