sql-data-services

Should I use "using" on my SitkaSoapServiceClient?

(This relates to Microsoft's SitkaSoapService, in the service reference at https://database.windows.net/soap/v1/) I'm using SitkaSoapServiceClient to access my SQL Data Services database by SOAP. Should I use a "using" statement every time I use this proxy class? Or does it do its own connection handling in a safe way internally? I.e....

SQL Data Services database design guidelines

I've been playing around lately with SQL Data Services. Although (or perhaps because) I can knock out a well-structured relational database in my sleep, I'm struggling to get my head round how to design a performant database in an environment that has (for example) no enforcement of referential integrity and no indexes on columns other t...

SQL Data Services - querying for null

(This relates to Microsoft's SitkaSoapService, in the service reference at https://database.windows.net/soap/v1/) I'm using SitkaSoapServiceClient to access my SQL Data Services database by SOAP. I can query data by passing a linq statement in a string, such as: Scope scope = new Scope(); scope.AuthorityId = authorityId; scope.Contain...

Accessing SQL Data Services via ADO.NET Data Service Client Library

Is this possible? Basically I would like to use SQL Data Services REST interface and let the ADO.NET Data Service Client library handle communication details and generate the entities that I can use. I looked at the samples in February release of Azure services kit but the samples in there are using HttpWebRequest and HttpWebResponse to ...