C＃中MongoDB查询报告的最佳方式是什么？

Question

我正在将我的报告网站从MySQL转换为C＃中的MongoDB。 到目前为止，我很满意MongoDB插入数据。 现在，从收藏中，我需要打印出来。

原来，我的查询是这样的

strSQL = "SELECT " + 
       " '" + strSearchingStartDate + "' AS SearchStartDate, '" + strSearchingEndDate + "' AS SearchEndDate, '" + strCurrentUserName + "' as WhoPrint, " + 
       " machinelograwdata.MachineID , " + 
       " machinelograwdata.Parameter1 AS 'Code', " + 
       " machinelograwdata.Parameter42 AS 'Orders', " + 
       " Temp2.HideStartTime AS StartTime, " + 
       " machinelograwdata.EndTime, " + 
       " UNIX_TIMESTAMP(machinelograwdata.EndTime) - UNIX_TIMESTAMP(Temp2.HideStartTime) AS Duration, " + 
       " Temp.StartTime AS CutStartTime, " + 
       " Temp.EndTime AS CutEndTime, " + 
       " Temp.Duration AS CutDuration, " + 
       " NULL AS NestingStartTime, " + 
       " NULL AS NestingEndTime, " + 
       " '0.00' AS NestingDuration, " + 
       " '0.00' AS 'SupplierAream2', " + 
       " ROUND(machinelograwdata.Parameter3/1000000, 2) AS 'GrossAream2', " + 
       " ROUND(machinelograwdata.Parameter26/1000000, 2) AS 'NetAream2', " + 
       " machinelograwdata.Parameter27 AS 'YieldPercen', " + 
       " machinelograwdata.Parameter25 AS 'NoPiece', " + 
       " machinelograwdata.Parameter24 AS 'Material', " + 
       " machinelograwdata.Parameter44 AS 'Models', " + 
       " ROUND(machinelograwdata.Parameter9/1000000, 2) AS 'Quantity0Area', " + 
       " '0.00' AS 'Quantity1Area', " + 
       " '0.00' AS 'Quantity2Area' " + 
       " FROM " + 
       " machinelograwdata " + 
       " INNER JOIN catalogue" + 
       " ON machinelograwdata.EventID = catalogue.CatalogueID " + 
       " LEFT JOIN " + 
       " (SELECT MachineID, Parameter1, EndTime, StartTime, UNIX_TIMESTAMP(EndTime) - UNIX_TIMESTAMP(StartTime) AS Duration " + 
       " FROM " + 
       "  (SELECT machinelograwdata.MachineID, machinelograwdata.Parameter1, " + 
       "   MAX(machinelograwdata.EndTime) AS EndTime, " + 
       "   MIN(machinelograwdata.StartTime) AS StartTime " + 
       " FROM " + 
       "  machinelograwdata, catalogue " + 
       " WHERE " + 
       "  machinelograwdata.EventID = catalogue.CatalogueID " + 
       "   AND catalogue.CatalogueGroup = 'EventDesc' " + 
       "   AND StartTime >= '" + strSearchingStartDate + "' " + 
       "   AND StartTime <= '" + strSearchingEndDate + "' " + 
       "   AND EventID = '15' " + 
       "   AND machinelograwdata.Parameter2 = '0' " + 
       " GROUP BY machinelograwdata.Parameter1, machinelograwdata.MachineID) M) Temp " + 
       " ON Temp.Parameter1 = machinelograwdata.Parameter1 " + 
       " AND Temp.MachineID = machinelograwdata.MachineID " + 
       " LEFT JOIN " + 
       " (SELECT MachineID, Parameter1, MIN(StartTime)AS HideStartTime " + 
       " FROM machinelograwdata " + 
       " WHERE EventID = '13' " + 
       "  AND machinelograwdata.StartTime <= '" + strSearchingEndDate + "' " + 
       "  AND machinelograwdata.StartTime >= '" + strSearchingStartDate + "' " + 
       " GROUP BY MachineID, Parameter1) Temp2 " + 
       " ON Temp2.Parameter1 = machinelograwdata.Parameter1 " + 
       " AND Temp2.MachineID = machinelograwdata.MachineID " + 
       " WHERE catalogue.CatalogueGroup = 'EventDesc' " + 
       "  AND machinelograwdata.StartTime <= '" + strSearchingEndDate + "' " + 
       "  AND machinelograwdata.StartTime >= '" + strSearchingStartDate + "' " + 
       "  AND EventID = '14' " + 
       "  AND CONVERT(Parameter35, DECIMAL) <> 0 " + 
       " ORDER BY machinelograwdata.MachineID , machinelograwdata.StartTime; "; 

我的问题是，有可能是我写的MongoDB用相同的查询？

并在MongoDB上有“查看”的概念？因为我有另一个使用View的MySQL报告查询。

我很感激您是否有任何建议或建议。 谢谢， Thomas

Answer 1

MongoDB和MySQL是两个非常不同的数据库解决方案。两者在维护数据方面都遵循不同的方法。 MongoDB没有SQL数据库意味着存储在其中的数据不会与MySQL数据库中的数据模式绑定。

您无法使用SQL查询从MongoDB中获取数据。 MongoDB拥有自己的查询引擎（由Javascript支持）来获取数据。

MongoDB不支持概念视图。

正如你可以从MySQL使用C＃MongoDB中加载数据，我会建议检查MongoDB官方C# drivers在地图减少操作。

一种方法是获取内存中的数据，然后生成报告。您可能还会发现一些在线解决方案将SQL查询映射到Mongo，如this