Hi everyboby, we've been working on the web services to interoperate Cach� 5.0.9 with .NET, and after a try we gave up using the %XML.DataSet: - we were unable to get a typed dataset that .NET would accept to merge with a client side typed dataset - no diffgram are accepted by Cach� on Import (but this is normal, as the XMLInport method is not for public use)
So we decided to do it another way: For the Query: - we inherited from the %ResulSet (like in %XML.DataSet) and created a method that return the query result in one string of XMLed DataSet, including the .NET DataSet Name and the .NET Schema namespace - this query could fill many tables in one call, as we could concatenate the different query results in the string - A webservice was created that runs que query and returns the result string - on .NET client side, this string is processed by a StringReader and merged with the typed DataSet. As the XML string is labelled with the namespace, the merge operation runs well, without including any schema. For the Update we intend to treat directly a Microsoft DiffGram DataSet, that is: - retrieve the Cach� class - parse every object and retrieve the operation (insertion, modification, deletion) - perform the correct operation on Cach� objects - build another DiffGram DataSet made of the objets that were modified by Cach� (e.g: date of creation is added by Cach� and must return to the client side) - return the XMLed DiffGram to the client side, who will perform a merge with existing data (we already have coded and tested this part) Today we achieved these operations with an additional tiers made in .NET, consisting in a translating .NET Dataset into ODBC operations (queries and stored procedures). The client connects to this server tiers with .NET remoting on a webservice (with data compression) This works fine but the performance could surely be enhanced by a direct call to a Cach� webservice. My questions are: - has anyone an opinion on this architecture ? - has anyone any piece of code that could process DiffGram in Cach� ? - has anyone the implementation of zlib compression in Cach� ? Thank you all to make this ng so live. JM PS: anyone interested in our work can contact me directly
