C# LINQ系列：LINQ to DataSet的DataTable操作 及 DataTable与Linq相互转换

DataSet ds = new DataSet();
// 省略ds的Fill代码
DataTable products = ds.Tables["Product"];
IEnumerable rows = from p in products.AsEnumerable()
                            select p;
foreach (DataRow row in rows)
{
    Console.WriteLine(row.Field("ProductName"));
}

DataSet ds = new DataSet();
// 省略ds的Fill代码
DataTable products = ds.Tables["Product"];
var rows = products.AsEnumerable()
    .Select(p => new
    {
        ProductID = p.Field("ProductID"),
        ProductName = p.Field("ProductName"),
        UnitPrice = p.Field("UnitPrice")
    });
foreach (var row in rows)
{
    Console.WriteLine(row.ProductName);
}

var products = ds.Tables["Product"].AsEnumerable();
var query = from p in products
            select p.Field("ProductName");

var rows = products.AsEnumerable()
    .Where(p => p.Field("UnitPrice") > 10m)
    .Select(p => new
    {
        ProductID = p.Field("ProductID"),
        ProductName = p.Field("ProductName"),
        UnitPrice = p.Field("UnitPrice")
    });

var rows = products.AsEnumerable()
    .Where(p => p.Field("UnitPrice") > 10m)
    .OrderBy(p => p.Field("SortOrder"))
    .Select(p => new
    {
        ProductID = p.Field("ProductID"),
        ProductName = p.Field("ProductName"),
        UnitPrice = p.Field("UnitPrice")
    });

var expr = from p in products.AsEnumerable()
            orderby p.Field("SortOrder")
            select p;
IEnumerable rows = expr.ToArray();
foreach (var row in rows)
{
    Console.WriteLine(row.Field("ProductName"));
}

var expr = from p in ds.Tables["Product"].AsEnumerable()
           orderby p.Field("SortOrder"), p.Field("ProductName") descending
           select p;

var query = from p in ds.Tables["Product"].AsEnumerable()
            from c in ds.Tables["Category"].AsEnumerable()
            where p.Field("CategoryID") == c.Field("CategoryID")
                && p.Field("UnitPrice") > 10m
            select new
            {
                ProductID = p.Field("ProductID"),
                ProductName = p.Field("ProductName"),
                CategoryName = c.Field("CategoryName")
            };

var query = from p in ds.Tables["Product"].AsEnumerable()
            group p by p.Field("CategoryID") into g
            select new
            {
                CategoryID = g.Key,
                Products = g
            };

foreach (var item in query)
{
    Console.WriteLine(item.CategoryID);
    foreach (var p in item.Products)
    {
        Console.WriteLine(p.Field("ProductName"));
    }
}

var expr = from p in ds.Tables["Product"].AsEnumerable()
           group p by p.Field("CategoryID") into g
           select new
           {
               CategoryID = g.Key,
               ProductsCount = g.Count()
           };