fixes sql for sqlce for data integrity controller

Shazwazza · Shazwazza · commit ad268ca1a6a9 · 2014-12-30T12:58:55.000+11:00
diff --git a/src/Umbraco.Web/WebServices/XmlDataIntegrityController.cs b/src/Umbraco.Web/WebServices/XmlDataIntegrityController.cs
@@ -35,12 +35,14 @@ public bool FixMembersXmlTable()
         public bool CheckContentXmlTable()
         {
             var totalPublished = Services.ContentService.CountPublished();
+            
             var subQuery = new Sql()
-                .Select("Count(DISTINCT cmsContentXml.nodeId)")
+                .Select("DISTINCT cmsContentXml.nodeId")
                 .From<ContentXmlDto>()
                 .InnerJoin<DocumentDto>()
                 .On<DocumentDto, ContentXmlDto>(left => left.NodeId, right => right.NodeId);
-            var totalXml = ApplicationContext.DatabaseContext.Database.ExecuteScalar<int>(subQuery);
+
+            var totalXml = ApplicationContext.DatabaseContext.Database.ExecuteScalar<int>("SELECT COUNT(*) FROM (" + subQuery.SQL + ") as tmp");
 
             return totalXml == totalPublished;
         }
