Thursday, May 15, 2008 6:44 AM
jonathanparker
SQL Server Data Services
I've signed up fro the SQL Server Data Services (MSSDS) and have started to play around with the API.
It's quite nice and simple. Here's an example of how to get your data in the cloud with MSSDS.
- Add a Web Reference to any .NET 2.0+ project. I'll be calling it SitkaClient (Sitka is the code name for MSSDS).
- WSDL url is http://data.beta.mssds.com/soap/v1?wsdl but you'll need to sign up to get a username and password.
- Optionally change your Web.config/App.config to support SSL by doing the following
- Call the web service.
It's that easy.
Here's a few examples of what you can do.
- Define a few constants
- Create an Authority
- Create a Container
- Create an Entity
These example use a few extension methods I created for the SitkaSoapServiceClient class.
Here's the code from the Extension class which is specific to a console application because it writes to the console output:
DOWNLOAD (ZIP): SQLServerDataServices.zip