I'm exporting a dataset as XML, including the schema, using the ACE.OLEDB.12.0 provider. I try to read that same XML into a dataset using the SQLClient provider, and all fields that are GUID fields are not recognized, which results in a "Column Requires a valid DataType" error.

The XML schema shows this for the GUID fields (except that the field names are different):

Code:
<xs:element name="SurveyID" msdata:DataType="System.Guid, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e" type="xs:string" minOccurs="0" />
I realize that JSON is the in thing, these days, but I have a couple different programs writing to this service. Changing everything over wouldn't be so easy.

Any suggestions?