LINQ to SQL 与 SQL Server Reporting Services，哪一个足以满足以下任务？
关于内容使用情况的基本报告，包括查看媒体资产所花费的时间、进度和交互性（基于完成或正确的百分比），最多可提供数万名用户。基于基本表格和文本的报告。一切都在 SQL Server 2005 数据库中。对我来说，我不认为我应该在优化 LINQ to SQL 时遇到麻烦，以使其足够好，但是利用 Reporting Services 会带来巨大的收益吗？我最初的想法是，工作量会更高，而且考虑到我生成的数据类型和基本报告，我无法实现比使用 LINQ 所能实现的更多的成果。有人有这方面的经验吗？
Basic reporting on content usage including time spent viewing a media asset, progress and interactivity based on % complete or correct for up to tens of thousands of users. Basic table and text based reports. Everything is in a SQL Server 2005 database. To me I don't feel like I should have trouble optimizing the LINQ to SQL to be good enough for this, but would there be a great gain from harnessing the Reporting Services? My initial thought is that the amount of effort would be higher and that I won't be able to achieve much more than what is possible with LINQ given the type of data and basic reports I am generating. Anyone have experience with this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我更希望您选择 SSRS，但这只是因为您自己也同意不必以效率为中心。 Linq2Sql 是一个不错的选择，但 SSRS 提供了一种非常 MS 的方式来做这些事情。您拥有良好的 GUI、向导和简单的可配置性。
SSRS 的优点不仅在于易于开发，还在于维护和调整报告。您的报告不会是静态的，可能会随着时间的推移而变化。在 SSRS 中调整报告要容易得多，新手也可以完成。 RDL 格式是基于XML 的，这也是一个优点。您可以随时轻松共享和协作。
总结一下：
SSRS
优点：
易于使用
新手用户可以开发/更改
有利于可维护性
也适用于基于图形的报告
缺点：
速度
软件成本:)
Linq2Sql
优点：
速度
缺点：
开发/维护/变更所需的专业知识
改变困难
I'd prefer you to go with SSRS but only because you yourself have agreed that you don't have to be efficiency centric. Linq2Sql is a good option but SSRS provides a very MS-way of doing this stuff. You have a good GUI, wizards, easy configurability.
The advantages of SSRS are not only in the ease of development but also in maintaining and tweaking the reports. Your reports won't be static and may change over time. And tweaking reports in SSRS is MUCH easier and can be done by a novice also. The RDL format is XML-based which is also an advantage. You can always share it and collaborate easily.
To Summarize:
SSRS
Pros:
Ease of use
Can be developed/changed by novice uesrs
Good for maintainability
Nice for graphic-based reports too
Cons:
Speed
S/w Cost :)
Linq2Sql
Pros:
Speed
Cons:
Expertise required to develop/maintain/change
Difficult in changing
我不会仅根据效率来选择报告服务。 SSRS 有大量您可能需要也可能不需要的功能。如果效率是您唯一的决定，那么我会说它介于 LINQ2SQL 和通过存储过程对数据库运行查询之间。
I would not choose reporting services based on efficiency only. SSRS has a ton of features that you may or may not need. If efficiency is your only decision, then I would say it is between LINQ2SQL and just running a query to the DB through a stored procedure.