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");
}
