int count = (from address in db.JobsDistribution
where address.Active == true
I was getting a compile error: Missing ; on line xx.
It turned that the default compiler used by the SharePoint 2010 web application was .NET Framework 2.0. This issue was fixed by adding the following section in the web.config file of the application within the <configuration> section: