Web Service Software Factory and XML Data Columns
Posted by Keith Elder | Posted in Web Services | Posted on 30-05-2007
I found a rusty washer today while trying to generate stored procedures for the data access tier with Web Service Software Factory to build out a new service. Apparently the software factory cannot handle XML data columns in a database. Definitely disappointing. Here is what it does in the guidance.
Basically it flags it as “The table cannot be selected because it contains column data types that are not supported.”. My fix was to change the column to varchar(max) and then generate what I needed and then change the generated code. But why? We have a data type of XmlDocument! Seems pretty easy to just set the property of the generated code to XmlDocument by default. I don’t get it.