(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....
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...
(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...
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 ...