Tuesday, 15 March 2011

xml - XElement changes slightly when stored in SQL Server -



xml - XElement changes slightly when stored in SQL Server -

i store xml value sql server table column of type [xml]. when store value containing empty string retrieve in different notation:

<storeme xmlns=""> <imempty /> </storeme>

will retrieve

<storeme xmlns=""> <imempty></imempty> </storeme>

this causing me problem, since programme storing xml should compare old value , xnode.deepequal returns false if compare these 2 versions of data.

i need way compare these 2 without dismanteling them original field. xnode.deepequal thinks different, there improve way can work out these same?

xml

No comments:

Post a Comment