public void XML_Data_ScriptsCorrectly() { string baseData = "<r><n1 myattrib=\"testattrib\">Some Data</n1></r>"; object data = baseData; var fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 64, "xml", false, 0, 0); Assert.AreEqual("N'<r><n1 myattrib=\"testattrib\">Some Data</n1></r>'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "xml"); Assert.AreEqual("<r><n1 myattrib=\"testattrib\">Some Data</n1></r>", FieldScripting.formatXml(data, false), "xml"); baseData = "<r><n1 myattrib=\"testattrib\">Some Data</n1><n2>Property escaping... that's important.</n2></r>"; data = baseData; fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 64, "xml", false, 0, 0); Assert.AreEqual("N'<r><n1 myattrib=\"testattrib\">Some Data</n1><n2>Property escaping... that''s important.</n2></r>'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "xml escapes quotes in strings"); Assert.AreEqual("<r><n1 myattrib=\"testattrib\">Some Data</n1><n2>Property escaping... that's important.</n2></r>", FieldScripting.formatXml(data, false), "xml"); }