且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用Dapper从T-SQL存储过程返回XML字符串

更新时间:2023-02-06 07:49:26

经过测试,我发现Dapper确实支持从存储过程中提取XML。

After testing, I see that Dapper does indeed support pulling the XML from stored procedures.

var result = conn.Query<string>(@"select * from <someTable> for xml auto");

这将返回一个字符串数组,每个元素最多包含2,033个字符,您可以简单地加入

This will return an array of string with each element containing up to 2,033 characters, which you can simple join to have your result as a single string.

var fullResult = string.Join("", result);

var fullResult = string.Concat(result);

或全部一步:

var result = string.Concat(conn.Query<string>(
    @"select * from <someTable> for xml auto", buffered: false));

因此,我不需要自己实现ExcuteXmlReader方法,现在我可以让Dapper处理参数通常。

So, there is no need for me to implement ExcuteXmlReader method myself, and now I can let Dapper handle the parameters normally.