LINQ to SQL 可以在数据库服务器端查询 XML 字段吗

在LINQ to SQL中，可以在数据库服务器端查询XML字段。XML字段是一种数据库字段类型，可以存储XML数据。通过使用LINQ to SQL，可以方便地查询和操作这些XML字段。

csharp
[Table(Name = "Customers")]
public class Customer
{
    [Column(Name = "ID", IsPrimaryKey = true, IsDbGenerated = true)]
    public int ID { get; set; }
    [Column(Name = "Name")]
    public string Name { get; set; }
    [Column(Name = "Address")]
    public XElement Address { get; set; }
}

csharp
using (var db = new DataContext())
{
    var customers = from c in db.GetTable()
                    where c.Address.Element("City").Value == "New York"
                    select c;
    foreach (var customer in customers)
    {
        Console.WriteLine("Customer ID: {0}", customer.ID);
        Console.WriteLine("Customer Name: {0}", customer.Name);
        Console.WriteLine("Customer Address: {0}", customer.Address);
        Console.WriteLine("----------------------------------");
    }
}

csharp
using System;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Xml.Linq;
namespace LinqToSqlXmlQuery
{
    [Table(Name = "Customers")]
    public class Customer
    {
        [Column(Name = "ID", IsPrimaryKey = true, IsDbGenerated = true)]
        public int ID { get; set; }
        [Column(Name = "Name")]
        public string Name { get; set; }
        [Column(Name = "Address")]
        public XElement Address { get; set; }
    }
    class Program
    {
        static void Main(string[] args)
        {
            using (var db = new DataContext())
            {
                var customers = from c in db.GetTable()
                                where c.Address.Element("City").Value == "New York"
                                select c;
                foreach (var customer in customers)
                {
                    Console.WriteLine("Customer ID: {0}", customer.ID);
                    Console.WriteLine("Customer Name: {0}", customer.Name);
                    Console.WriteLine("Customer Address: {0}", customer.Address);
                    Console.WriteLine("----------------------------------");
                }
            }
            Console.ReadLine();
        }
    }
}