public void HIERARCHYID_Data_ScriptsCorrectly() { SqlHierarchyId baseData = SqlHierarchyId.Parse("/"); object data = baseData; var fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 20, "sys.junk.hierarchyid", false, 0, 0); Assert.AreEqual("0x", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "hierarchyid"); Assert.AreEqual("0x", FieldScripting.formatHierarchyId(data), "hierarchyid"); baseData = SqlHierarchyId.Parse("/1/"); data = baseData; fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 20, "sys.junk.hierarchyid", false, 0, 0); Assert.AreEqual("0x58", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "hierarchyid"); Assert.AreEqual("0x58", FieldScripting.formatHierarchyId(data), "hierarchyid"); }