public ActionResult PackageVersion(Guid packageVersionId) { var dataAdapterDependencies = new PortalConfigurationDataAdapterDependencies(requestContext: Request.RequestContext); var dataAdapter = new AnnotationDataAdapter(dataAdapterDependencies); var serviceContext = dataAdapterDependencies.GetServiceContext(); var query = from a in serviceContext.CreateQuery("annotation") join v in serviceContext.CreateQuery("adx_packageversion") on a["objectid"] equals v["adx_packageversionid"] where a.GetAttributeValue <string>("objecttypecode") == "adx_packageversion" where a.GetAttributeValue <bool?>("isdocument") == true where v.GetAttributeValue <Guid>("adx_packageversionid") == packageVersionId where v.GetAttributeValue <OptionSetValue>("statecode") != null && v.GetAttributeValue <OptionSetValue>("statecode").Value == 0 orderby a["createdon"] descending select a; var note = query.FirstOrDefault(); return(note == null?HttpNotFound() : dataAdapter.DownloadAction(Response, note)); }