(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.ContainerId = containerId;
using (SitkaSoapServiceClient proxy = GetProxy())
return proxy.Query(scope, "from e in entities where e[\"FirstName\"] == \"Bob\" select e");
However, I can't figure out how to query for a null property value (i.e. find entities without that property).
I'd expect to be able to say:
return proxy.Query(scope, "from e in entities where e[\"FirstName\"] == null select e");
... but that throws a FaultException<>
, saying "The name 'null' could not be found"
Any ideas?