使用 linq 从动态 SQL 查询中检索和打印数据

using System;
using System.Linq;
using System.Data.Linq;
using System.Data.Linq.Mapping;

[Table(Name = "Orders")]
class Order
{
    [Column(IsPrimaryKey = true)]
    public int OrderID { get; set; }

    [Column]
    public string CustomerID { get; set; }

    [Column]
    public int Total { get; set; }
}

class Program
{
    static void Main(string[] args)
    {
        DataContext db = new DataContext("connectionString");

        var orders = from o in db.GetTable<Order>()
                     where o.CustomerID == "ALFKI"
                     select o;

        foreach (var order in orders)
        {
            Console.WriteLine("OrderID: {0}, Total: {1}", order.OrderID, order.Total);
        }
    }
}