Update namespace of xml column

Sp0rk-eh

New Member
After refactoring I found that its needed to change namespace of existing data. Each db row contains column with data like:\[code\]<Bla xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.contoso.com/ooo/entities/v1"> <Titles> <smth sourceId="19" targetId="2"> <smth2>New</smth2> </smth> </Titles></Bla>\[/code\]How to update value \[code\]xmlns="http://schemas.contoso.com/ooo/entities/v1"\[/code\] to be \[code\]xmlns="http://schemas.contoso.com/ooo/common/v1"\[/code\]Actual exception is \[code\]InvalidOperationException\[/code\] (namespace was not expected). m.b it's possible to change data reader deserialization but...
 
Back
Top