Microsoft Reporting Services。我应该使用webservices作为数据源吗?

时间:2021-08-11 08:01:36

I have a dilemma. Here is my set-up: ASP.NET/NET 3.5 web application build using standards(DB layers, BL layers, etc...)

我陷入两难境地。这是我的设置:使用标准的ASP.NET / NET 3.5 Web应用程序构建(DB层,BL层等...)

I need to generate some reports. Standard way of doing that is to have reporting service query database directly OR I can have reporting services query web services(which I will create).

我需要生成一些报告。标准的方法是直接使用报表服务查询数据库,或者我可以使用报表服务查询Web服务(我将创建)。

I like web services approach because if underlying schema changes, I only need to make sure that my web services return correct data. Reporting services are not affected.

我喜欢Web服务方法,因为如果底层架构发生变化,我只需要确保我的Web服务返回正确的数据。报告服务不受影响。

If using direct query to the database, reporting services need to be updated.

如果对数据库使用直接查询,则需要更新报告服务。

Should I use web services(http://msdn.microsoft.com/en-us/library/aa964129(SQL.90).aspx) or direct queries?

我应该使用Web服务(http://msdn.microsoft.com/en-us/library/aa964129(SQL.90).aspx)还是直接查询?

2 个解决方案

#1


0  

I think a better approach would be (if possible) to use services as your API for both (application and reporting services). That would keep the code/logic in a central spot as well as accomplish your goals on the reporting services.

我认为更好的方法是(如果可能的话)将服务用作两者的API(应用程序和报告服务)。这将使代码/逻辑保持在中心位置,并实现您在报告服务上的目标。

#2


2  

Using a web service makes maintenance easier. The performance will suffer some but to what extent is relative to your hardware, database design, queries, etc... I would use the web service as this is the way Adobe Flex applications are suppose to do it and Microsoft WCF seems to be pointing DotNet developers in the direction of web service data sources.

使用Web服务可以简化维护。性能将受到一些影响,但相对于您的硬件,数据库设计,查询等程度...我将使用Web服务,因为这是Adobe Flex应用程序假设这样做的方式,Microsoft WCF似乎指向DotNet开发人员在Web服务数据源的方向。

Another benefit is that you can use multiple clients with the same service.

另一个好处是您可以使用具有相同服务的多个客户端。

#1


0  

I think a better approach would be (if possible) to use services as your API for both (application and reporting services). That would keep the code/logic in a central spot as well as accomplish your goals on the reporting services.

我认为更好的方法是(如果可能的话)将服务用作两者的API(应用程序和报告服务)。这将使代码/逻辑保持在中心位置,并实现您在报告服务上的目标。

#2


2  

Using a web service makes maintenance easier. The performance will suffer some but to what extent is relative to your hardware, database design, queries, etc... I would use the web service as this is the way Adobe Flex applications are suppose to do it and Microsoft WCF seems to be pointing DotNet developers in the direction of web service data sources.

使用Web服务可以简化维护。性能将受到一些影响,但相对于您的硬件,数据库设计,查询等程度...我将使用Web服务,因为这是Adobe Flex应用程序假设这样做的方式,Microsoft WCF似乎指向DotNet开发人员在Web服务数据源的方向。

Another benefit is that you can use multiple clients with the same service.

另一个好处是您可以使用具有相同服务的多个客户端。