System.Xml.XmlException: Unexpected end tag

[kstrohminfor]

Describe the bug

Unable to iterate through results with an xml column with a sql reader.

System.Xml.XmlException: Unexpected end tag. Line 1, position 13.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlWriter.WriteNode(XmlReader reader, Boolean defattr)
   at System.Data.SqlTypes.SqlXml.get_Value()
   at Microsoft.Data.SqlClient.SqlCachedBuffer.ToString()
   at Microsoft.Data.SqlClient.SqlBuffer.get_String()
   at Microsoft.Data.SqlClient.SqlDataReader.GetString(Int32 i)

To reproduce

https://github.com/kstrohminfor/SqlReaderIssue

Expected behavior

The sql reader should be able to iterate through results with an xml column without error.

Further technical details

Microsoft.Data.SqlClient version: 6.1.0-preview1.25120.4
.NET target: .NET 8.0
SQL Server version: 2022
Operating system: Windows 11

[Wraith2]

This is an issue discovered using preview 6.1 with the new async handling enabled. We discussed it on discord and verified that using the configuration switch to disable async-continue fixes it. I will investigate.

[Wraith2]

I understand the problem. It's a tiny edge case present only in xml reads because they go through SqlCachedbuffer. Prospective fix is opened in #3329