\nAnother little thing I'd found had changed in Dec CTP. I'd reported a bug on this one and knew it was gonna be fixed eventually, but better sooner than later. I came up when Dan Sullivan suggested his "universal web service" based on SQL Server's XML data type and XML Schema Collections. Here's the prototype:\n<\/p>\n
\nCREATE PROCEDURE some_ws (
\n @somexmlinout OUT xml(someothercoll))
\nAS
\n— your code goes here
\n— or your external name does\n<\/p>\n
\nIn previous versions, the HTTP Endpoint that defined this web service generated WSDL that, when uses with VS-proxy-generator, looked (coersed into objects) like this:\n<\/p>\n
\nsome_wssomexmlinout i = new some_wssomexmlinout();
\nsome_wsResponsesomexmlinout j = new Responsesomexmlinout();\n<\/p>\n
\nObject[] o = endpoint.some_ws(i, out j);\n<\/p>\n
\nRepresenting the SQL OUTPUT variable as two variables not only made this more complex, but freaked out VB.NET proxy which doesn't really have a built-in concept of output-only parameters (though its possible to do with an attribute).\n<\/p>\n
\nIn Dec CTP, the "universal web service" builds proxies that look like this:\n<\/p>\n
\nsome_wsTypesomexmlinout i = new some_wsTypesomexmlinout();\n<\/p>\n
\nObject[] o = endpoint.some_ws(ref i);\n<\/p>\n
\nThat's better. Even VB.NET likes it. Now if only I could provide a schema collection (or indicate in the endpoint definition) so that the WSDL would reflect (the only) two types in the namespace. Rather than it's (completely correct) definition of this as "any" from a collection of namesapces (those defined by the schema collection).\n<\/p>\n
\nWell, unitl that happens, there is always custom WSDL generation…\n<\/p>\n
\nNotice that this MUST have been a fix to HTTP Endpoint WSDL-generator, because my version of Visual Studio web service proxy generator (Oct CTP) was unchanged. Cool.<\/p>\n","protected":false},"excerpt":{"rendered":"
Another little thing I'd found had changed in Dec CTP. I'd reported a bug on this one and knew it was gonna be fixed eventually, but better sooner than later. I came up when Dan Sullivan suggested his "universal web service" based on SQL Server's XML data type and XML Schema Collections. Here's the prototype: […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,37],"tags":[],"class_list":["post-984","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005","category-sql-server-xml"],"yoast_head":"\n