Dapper/tests/Dapper.Tests/XmlTests.cs

using System.Xml;
using System.Xml.Linq;
using Xunit;

namespace Dapper.Tests
{
    [Collection("XmlTests")]
    public sealed class SystemSqlClientXmlTests : XmlTests<SystemSqlClientProvider> { }
#if MSSQLCLIENT
    [Collection("XmlTests")]
    public sealed class MicrosoftSqlClientXmlTests : XmlTests<MicrosoftSqlClientProvider> { }
#endif
    public abstract class XmlTests<TProvider> : TestBase<TProvider> where TProvider : DatabaseProvider
    {
        [Fact]
        public void CommonXmlTypesSupported()
        {
            var xml = new XmlDocument();
            xml.LoadXml("<abc/>");

            var foo = new Foo
            {
                A = xml,
                B = XDocument.Parse("<def/>"),
                C = XElement.Parse("<ghi/>")
            };
            var bar = connection.QuerySingle<Foo>("select @a as [A], @b as [B], @c as [C]", new { a = foo.A, b = foo.B, c = foo.C });
            Assert.Equal("abc", bar.A?.DocumentElement?.Name);
            Assert.Equal("def", bar.B?.Root?.Name.LocalName);
            Assert.Equal("ghi", bar.C?.Name.LocalName);
        }

        public class Foo
        {
            public XmlDocument? A { get; set; }
            public XDocument? B { get; set; }
            public XElement? C { get; set; }
        }
    }
}