Feeds:
Posts
Comments

Posts Tagged ‘service’

Want to programmatically access your Sql Server Reporting Services Server? (SSRS) Turns out there’s an app for that! Or more precisely, a SOAP web service.

The Reporting Services SOAP API provides several Web service endpoints for developing custom reporting solutions. The endpoints currently fall into two categories: management and execution. The management functionality is exposed through the ReportService2005 and ReportService2006 endpoints. The ReportService2005 endpoint is used for managing a report server that is configured in native mode and the ReportService2006 endpoint is used for managing a report server that is configured for SharePoint integrated mode. The execution functionality is exposed through the ReportExecution2005 endpoint and it is used when the report server is configured in native or SharePoint integrated mode. The following topics show how these endpoints can be used for developing reporting solutions in Microsoft Windows, SharePoint, and Web applications.

via Integrating Reporting Services Using SOAP.

Advertisements

Read Full Post »

My service is broke-a$….er I mean my friend is having issues with his code and this is the link I sent him.

By default, Data Services don’t return information on what’s wrong when you try to execute some code, for example an update, against it. This is understandable: if you open up a data service on the web, you shouldn’t be returning all important information about entities in the underlying model.

However, when developing a Data Service, it might be handy to get a little more information than just “An error occurred while processing this request”. Here’s how to achieve this…

via Snowball – The Blog – Debugging ADO.NET Data Services.

Read Full Post »

ADO.NET Data Services provides filtering options for free.

What can go in a $filter? The most basic thing to do is to test properties of the resources we’re returning, which you can access simply by name, like we have done above. Literals for things like strings and numbers use the same syntax as in the key portion (see my last post and the original URL post for more details).

via Marcelo’s WebLog : $filter Query Option in ADO.NET Data Services.

Read Full Post »

Need to debug an ADO.NET Data Service?

Another interesting point has to do with error handling. The option for error handling is set during InitializeService. If an exception is thrown while InitializeService is being called, we don’t trust whatever was set on the configuration, and instead of the ADO.NET Data Service error handling kicking in, we’ll let the exception bubble out. Typically the service will be running as a WCF service, which means you’ll get the error page with the blue band on top (when viewed in a browser). To get detailed errors in this case, you can do something like this.

[System.ServiceModel.ServiceBehavior(IncludeExceptionDetailInFaults = true)]

public class YourService : DataService

{ … }

via Marcelo’s WebLog : So Special – InitializeService in ADO.NET Data Services.

Read Full Post »

Haven’t given this a try yet but I definitely plan to soon.

I build this tool to help me build ADO.NET Data Services URL query ( for example http://e4d.com/Courses.svc/Courses?$orderby=Date/ )

and to see the result. this is first version, please send feedback…

Key Features:

1. URL IntelliSense

2. URL Tooltip

3. Data Grid View

4. XML Atom View

5. Data Service Metadata View

via ADO.NET Data Services Viewer Tool – Home.

Read Full Post »