使用实体框架在Server 2008中插入完整XML时出错

Question

嗨，我正在尝试将XML文件插入到XML类型的Server表中

但这让我犯了以下错误

这是我的C#逻辑

  using (Entities context = new Entities())
            {
                context.usp_BF_StoreEligibilityResponse(ID, XML);
}

这是我的存储过程

 UPDATE  MyTable
SET     ResponseXML = cast('<?xml version="1.0"?>
<Interchange segment-terminator="~" element-separator="*" sub-element-separator="&gt;">
  <ISA>
    <!--Author Information Qualifier-->
    <ISA01>00<!--No Authorization Information Present--></ISA01>
    <!--Author Information-->
    <ISA02>          </ISA02>
    <!--Security Information Qualifer-->
    <ISA03>01<!--Password--></ISA03>
    <!--Security Information-->
    <ISA04>JILITTQQPK</ISA04>
    <!--Interchange ID Qualifier-->
    <ISA05>ZZ<!--Mutually Defined--></ISA05>
    <!--Interchange Sender ID-->
    <ISA06>S00000000000001</ISA06>
    <!--Interchange ID Qualifier-->
    <ISA07>ZZ<!--Mutually Defined--></ISA07>
    <!--Interchange Receiver ID-->
    <ISA08>T00000000021261</ISA08>
    <!--Interchange Date-->
    <ISA09>120328</ISA09>
    <!--Interchange Time-->
    <ISA10>1539</ISA10>
    <!--Inter Control Standards Identifier-->
    <ISA11>&#x1F;</ISA11>
    <!--Inter Control Version Number-->
    <ISA12>00501</ISA12>
    <!--Inter Control Number-->
    <ISA13>021443719</ISA13>
    <!--Acknowlegment Requested-->
    <ISA14>0<!--No Acknowledgment Requested--></ISA14>
    <!--Usage Indicator-->
    <ISA15>T<!--Test Data--></ISA15>
    <!--Component Element Separator-->
    <ISA16>
      <ISA1601 />
      <ISA1602 />
    </ISA16>
  </ISA>
  <TA1>
    <!--Interchange control number-->
    <TA101>0fa080e2-</TA101>
    <!--Interchange Date-->
    <TA102>120328</TA102>
    <!--Interchange Time-->
    <TA103>1639</TA103>
    <!--Interchange ACK Code-->
    <TA104>R<!--Interchange rejected/suspended--></TA104>
    <!--Interchange Note Code-->
    <TA105>018</TA105>
  </TA1>
  <IEA>
    <!--Number of Included Functional Groups-->
    <IEA01>0</IEA01>
    <!--Interchange Control Number-->
    <IEA02>021443719</IEA02>
  </IEA>
</Interchange>' AS XML)
WHERE   EligibilityID = 13

错误消息

Msg 9420, Level 16, State 1, Line 1
XML parsing: line 25, character 17, illegal xml character
    enter code here

这是导致此错误的行<ISA11>&#x1F;</ISA11>。

当我在视图或HTML视图中预览时，它看起来像下面的<ISA11></ISA11>

Answer 1

错误信息是这样的。给定XML是无效的XML，因为是无效的文本序列。如果需要这样的文本，则必须输入为 (&是&符号的XML转义序列)。或者，您可以通过将字符串封装在CDATA (字符数据)部分：<![CDATA[&#x1F;]]>来转义字符串。