(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...
I am trying to come up with the "best" way to implement SQL Data Services flexible entity model where each class could be stored as an entity, even derrived classes. Example: Every subclass has different string Id string Kind Dictionary<string, object> Properties So far, I'm heading in the direction of having both an Entity class (wi...
If I do a query (I plan to use SDS.P) against the global catalog, what should the starting path be so I can search the entire GC? I want to enumerate all users in GC, for example. Let's say my gc has users for 3 domains (one parent, two children): TEST.COM ONE.TEST.COM TWO.TEST.COM and i'm on a computer in ONE.TEST.COM. I do no...