C#中MongoDB查询报告的最佳方式是什么?
问题描述:
我正在将我的报告网站从MySQL转换为C#中的MongoDB。 到目前为止,我很满意MongoDB插入数据。 现在,从收藏中,我需要打印出来。C#中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
答
MongoDB和MySQL是两个非常不同的数据库解决方案。两者在维护数据方面都遵循不同的方法。 MongoDB没有SQL数据库意味着存储在其中的数据不会与MySQL数据库中的数据模式绑定。
您无法使用SQL查询从MongoDB中获取数据。 MongoDB拥有自己的查询引擎(由Javascript支持)来获取数据。
MongoDB不支持概念视图。
正如你可以从MySQL使用C#MongoDB中加载数据,我会建议检查MongoDB官方C# drivers在地图减少操作。
一种方法是获取内存中的数据,然后生成报告。您可能还会发现一些在线解决方案将SQL查询映射到Mongo,如this
Hi @ Monk-Who-Code, 谢谢您的建议。 看起来,我将不得不做些功课才能使用MongoDB进行报告。 我想,我在内存中加载MongoDB并处理它。 所以,表现是我应该照顾的。 – ThomasLee