foreach遍历linq所有数据

foreach遍历linq所有数据
linq 能查询的数据

对象。比如集合、数组、字符串等等。
关系。分为 linq to dataset 和 linq to sql，前者用于 dataset 查询，后者用于 sql server select c;
        foreach (var customer in wacustomers) {
            console.writeline("customer {0}: {1}", customer.customerid, customer.companyname);
            foreach (var order in customer.orders) {
                console.writeline(" order {0}: {1}", order.id, order.orderdate);
            }
        }
    }
    static list<customer> getcustomerlist() {
        list<product> emptree = new list<product>();
        emptree.add(new product { productname = "a", category = "o", unitprice = 12, unitsinstock = 5, total = 36, orderdate = new datetime(2005, 1, 1), id = 1 });
        emptree.add(new product { productname = "b", category = "o", unitprice = 2, unitsinstock = 4, total = 35, orderdate = new datetime(2005, 1, 1), id = 1 });
        emptree.add(new product { productname = "c", category = "o", unitprice = 112, unitsinstock = 3, total = 34, orderdate = new datetime(2005, 1, 1), id = 1 });
        emptree.add(new product { productname = "d", category = "o", unitprice = 112, unitsinstock = 0, total = 33, orderdate = new datetime(2005, 1, 1), id = 1 });
        emptree.add(new product { productname = "e", category = "o", unitprice = 1112, unitsinstock = 2, total = 32, orderdate = new datetime(2005, 1, 1), id = 1 });
        emptree.add(new product { productname = "f", category = "o", unitprice = 11112, unitsinstock = 0, total = 31, orderdate = new datetime(2005, 1, 1), id = 1 });

        list<customer> l = new list<customer>();
        l.add(new customer { companyname = "a", region = "r1", unitsinstock = 1, orders = emptree, customerid =0});
        l.add(new customer { companyname = "b", region = "r2", unitsinstock = 2, orders = emptree, customerid = 1 });
        l.add(new customer { companyname = "c", region = "r3", unitsinstock = 3, orders = emptree, customerid = 2 });
        l.add(new customer { companyname = "d", region = "r4", unitsinstock = 4, orders = emptree, customerid = 3 });
        l.add(new customer { companyname = "e", region = "r5", unitsinstock = 5, orders = emptree, customerid = 4 });
        return l;
    }
}

class customer : icomparable<customer> {
    public string companyname { get; set; }
    public string region { get; set; }
    public list<product> orders { get; set; }
    public int unitsinstock { get; set; }
    public int customerid { get; set; }

    public override string tostring() {
        return string.format("id: {0}, name: {1}, region: {3}", this.customerid, this.companyname, this.region);
    }
    int icomparable<customer>.compareto(customer other) {
        if (other == null)
            return 1;

        if (this.customerid > other.customerid)
            return 1;

        if (this.customerid < other.customerid)
            return -1;

        return 0;
    }
}
class product : icomparable<product> {
    public string productname { get; set; }
    public string category { get; set; }
    public int unitprice { get; set; }
    public int unitsinstock { get; set; }
    public int total { get; set; }
    public datetime orderdate { get; set; }
    public int id { get; set; }

    public override string tostring() {
        return string.format("id: {0}, name: {1} , category: {3}", this.id, this.productname, this.category);
    }
    int icomparable<product>.compareto(product other) {
        if (other == null)
            return 1;
        if (this.id > other.id)
            return 1;

        if (this.id < other.id)
            return -1;

        return 0;
    }
}

您可能感兴趣的文章：
foreach遍历linq所有数据
Linq学习教程 Linq to Xml读取复杂xml及Linq to js使用
asp.net linq用法与object用法
php遍历数组之list foreach each用法总结
C#中的超级方法
php遍历数组的几种方法(for foreach list each while)
php遍历循环数组实现方法
php遍历数组list foreach each方法实例
php数组遍历方法详解(for foreach list each key)
php foreach 用法