Skip to content

System.Xml.XmlException: Unexpected end tag #3319

@kstrohminfor

Description

@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

Metadata

Metadata

Assignees

Labels

Triage Done ✔️Issues that are triaged by dev team and are in investigation.

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions