Linq2SQL获取动态选择的列的值

var query = from c in dbContext.Customers
            where c.City == "New York"
            select new { c.CustomerID, c.CompanyName, c.ContactName };

foreach (var result in query)
{
    Console.WriteLine("CustomerID: " + result.CustomerID);
    Console.WriteLine("CompanyName: " + result.CompanyName);
    Console.WriteLine("ContactName: " + result.ContactName);
}

public class CustomerInfo
{
    public string CustomerID { get; set; }
    public string CompanyName { get; set; }
    public string ContactName { get; set; }
}

var query = from c in dbContext.Customers
            where c.City == "New York"
            select new CustomerInfo { CustomerID = c.CustomerID, CompanyName = c.CompanyName, ContactName = c.ContactName };

foreach (var result in query)
{
    Console.WriteLine("CustomerID: " + result.CustomerID);
    Console.WriteLine("CompanyName: " + result.CompanyName);
    Console.WriteLine("ContactName: " + result.ContactName);
}