Featured Post

Sync Services for SQL Server Compact Edition 3.5 in Visual Studio 2008

One of the new features in Visual Studio 2008 provides the ability to easily sync data from the server to the client and the client to the server using Sync Services for ADO.Net.  For developers supporting Winform and Smart Clients this is a much welcomed feature.   Developers will be able...

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.