如何使用MemoryStream和Web API返回XML文件？WCF项目实操需求

后端C# WCF服务实现 #

1. 服务契约定义 #

[ServiceContract]
public interface IXmlDownloadService
{
    [WebInvoke(Method = "GET", UriTemplate = "DownloadXml")]
    Stream GenerateAndDownloadXml();
}

2. 服务逻辑实现 #

public class XmlDownloadService : IXmlDownloadService
{
    public Stream GenerateAndDownloadXml()
    {
        // 读取Oracle数据库数据
        string connStr = "Data Source=你的Oracle实例名;User Id=用户名;Password=密码;";
        string query = "SELECT * FROM 目标表名";
        
        DataSet dataSet = new DataSet("ExportData");
        using (OracleConnection conn = new OracleConnection(connStr))
        {
            using (OracleDataAdapter adapter = new OracleDataAdapter(query, conn))
            {
                adapter.Fill(dataSet, "Records");
            }
        }

        // 将数据写入MemoryStream生成XML
        MemoryStream ms = new MemoryStream();
        dataSet.WriteXml(ms, XmlWriteMode.WriteSchema);
        ms.Position = 0; // 重置流指针到起始位置

        // 设置响应头触发浏览器下载
        WebOperationContext.Current.OutgoingResponse.ContentType = "application/xml";
        WebOperationContext.Current.OutgoingResponse.Headers.Add(
            "Content-Disposition", 
            "attachment; filename=export_data.xml"
        );

        return ms;
    }
}

3. WCF配置（web.config） #

<system.serviceModel>
  <services>
    <service name="你的命名空间.XmlDownloadService">
      <endpoint 
          address="" 
          binding="webHttpBinding" 
          bindingConfiguration="StreamedBinding" 
          contract="你的命名空间.IXmlDownloadService" 
          behaviorConfiguration="WebBehavior"
      />
    </service>
  </services>
  <bindings>
    <webHttpBinding>
      <binding 
          name="StreamedBinding" 
          transferMode="StreamedResponse" 
          maxReceivedMessageSize="2147483647"
      />
    </webHttpBinding>
  </bindings>
  <behaviors>
    <endpointBehaviors>
      <behavior name="WebBehavior">
        <webHttp/>
      </behavior>
    </endpointBehaviors>
  </behaviors>
</system.serviceModel>

前端JS AJAX下载实现 #

function triggerXmlDownload() {
    const xhr = new XMLHttpRequest();
    xhr.open('GET', '/XmlDownloadService.svc/DownloadXml', true);
    xhr.responseType = 'blob'; // 指定响应为二进制Blob类型

    xhr.onload = function() {
        if (this.status === 200) {
            const blob = new Blob([this.response], { type: 'application/xml' });
            const downloadUrl = window.URL.createObjectURL(blob);
            
            const link = document.createElement('a');
            link.href = downloadUrl;
            link.download = 'export_data.xml';
            document.body.appendChild(link);
            link.click();
            
            // 清理资源
            window.URL.revokeObjectURL(downloadUrl);
            document.body.removeChild(link);
        }
    };

    xhr.onerror = function() {
        alert('XML文件下载失败，请检查服务状态');
    };

    xhr.send();
}

关键注意事项 #

• 确保项目引用Oracle.ManagedDataAccess NuGet包，用于Oracle数据库操作
• WCF绑定必须设置transferMode="StreamedResponse"，支持流式传输大文件
• 响应头Content-Disposition是触发浏览器下载的核心，必须包含attachment指令
• 前端需将AJAX响应类型设为blob，否则无法正确处理二进制流
• 若跨域访问服务，需在WCF端配置CORS支持

内容的提问来源于stack exchange，提问作者Saidvali