Featured Post

PHP with Apple’s Developer Tools

Many of you who have talked to me recently know of my excitement about OSX. I would switch to OSX today if Steve would buy me a new Mac, otherwise I am going to save my money and keep using a PC. Today though, long time Mac user shepardzone sent me some information about the new PHP development tools...

Read More


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.