更新时间: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.