XDocument.ToString() throwing "' ', hexadecimal value 0x13, is an invalid character." exception

Question

I want to store XDocument into the SQLXML Datatype. I went through this Link for storing XDOcument into the SQL DB. As per the link while Converting XDocumentObj.ToString() its throwing "' ', hexadecimal value 0x13, is an invalid character." exception. Can anyone please help me to fix the problem. How do I store the complete XML file into the database of type XML.

Answer 1

Somehow you got the character U+0013 in there, which is a control character for pausing transmission on serial datalinks. It's unlikely you actually want that, so the real issue isn't that there's a character that's invalid in XML in there, but that there's a character that just shouldn't be there, in there. So find out how it got in there, as that were the real bug is. I'd start by trapping whatever calls add to the document, and throwing when you find a string containing U+0013