ReadmeSSDS File for the SSDSNwindEntitiesCS Sample Project (VSM July 2008 Issue) Updated July 27, 2008

NOTE: This project is designed for use with v1 (Sprint #3) of the beta versions. It has been updated for Sprint #3 and uses the new 'application/x-ssds+xml' mime type for REST operations. A number of minor improvements, changes, and bug-fixes have been added.

This code _might_ require VS 2008 SP1 Beta 1 and will be updated for later SSDS/SP1 versions, if breaking changes occur.

This project will install in a \SSDSNwindEntitiesCS folder by default.

TIP: If you have a problem with the default SOAP protocol and have verified your UserName, Password, and AuthorityId, refresh the Service Reference. Alternatively, mark the Use REST check box to use the REST protocol temporarily.

1. This project requires the user to have a beta account for SQL Server Data Services (SSDS), which you can obtain by registering at http://www.microsoft.com/sql/dataservices/default.mspx, and an instance of the Northwind sample database attached to SQL Server 2005+ [Express].

2. It's recommended that you set your userId, AuthorityId, and, optionally, password as the Text value of the three corresponding text boxes.

3. To create and populate a Northwind container with all sample tables with the SOAP protocol, run the project and click the Create and Load Entities button.

4. To do the same with the REST protocol, mark the Use REST check box.

5. If you want to substitute Guids for alphanumeric Ids, mark the Use Guid for Id check box. SSDS will sort the entities in random (Guid string) order.

6. If you want to base64Encode and upload the Employees and Categories tables' image fields, mark the base64Binary-Encode images check box.

7. To create and populate a container for each table, mark the Container per Entity check box.

8. Clicking Bail Out terminates upload operations.

9. Clicking Get Orders retrieves (GETs) 83 orders having Brazil as the ShipCountry value.

10. Clicking Update Orders toggles the presence of a datetime Timestamp property.

11. Clikcking Delete Orders (SOAP only) deletes the Brazilian orders and offers the option to replace them after deletion.

The project has minimal error trapping so you can more easily determine where the problem occurred.

Enjoy!

roger_jennings@compuserve.com