使用Regex从XML字符串中删除XML节点名称空间前缀

I have some legacy XML documents stored in a database as a blob, which are not well formed XML. I'm reading them in from a SQL database, and ultimately, as I am using C#.NET, would like to instantiate them as an XMLDocument.I have some legacy XML documents stored in a da