使用带有Entity Framework的(Sql Server)xml列

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;
using System.Data.Entity;

namespace EntityFrameworkWithXmlColumn
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new MyDbContext())
            {
                // 创建一个新的实体对象
                var entity = new MyEntity
                {
                    Name = "Test",
                    XmlData = XElement.Parse("<root><child>Test</child></root>")
                };

                // 将实体对象添加到数据库中
                context.MyEntities.Add(entity);
                context.SaveChanges();

                // 从数据库中检索实体对象
                var retrievedEntity = context.MyEntities.FirstOrDefault(e => e.Name == "Test");
                Console.WriteLine(retrievedEntity.XmlData.ToString());
            }
        }
    }

    public class MyEntity
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public XElement XmlData { get; set; }
    }

    public class MyDbContext : DbContext
    {
        public DbSet<MyEntity> MyEntities { get; set; }
    }
}