Linq的多列GroupBy

2009 年 4 月 19 日 admin 9 comments

多列(Multiple Columns)
var categories =
from p in db.Products
group p by new
{
p.CategoryID,
p.SupplierID
}
into g
select new
{
g.Key,
g
};语句描述：使用Group By按CategoryID和SupplierID将产品分组。

说明：既按产品的分类，又按供应商分类。在by后面，new出来一个匿名类。这里，Key其实质是一个类的对象，Key包含两个Property：CategoryID、SupplierID。用g.Key.CategoryID可以遍历CategoryID的值。

C#.Net 3.5

9 comments

  1. 587 说道：
    2012 年 1 月 1 日 08:26
    回复
  2. Milan Toniatti 说道：
    2012 年 1 月 23 日 13:31

    I just want to say I am newbie to weblog and seriously enjoyed you’re blog site. Most likely I’m going to bookmark your website . You absolutely have perfect well written articles. Cheers for revealing your website page.

    回复
  3. 323 说道：
    2012 年 1 月 24 日 13:55
    回复
  4. Allan Furer 说道：
    2012 年 1 月 29 日 14:35

    Good write-up. I am a normal visitor of your site and appreciate you taking the time to maintain the nice site. I will be a regular visitor for a really long time.

    回复
  5. Lovie Farzan 说道：
    2012 年 1 月 31 日 19:37

    I am truly happy to glance at this weblog posts which consists of plenty of helpful information, thanks for providing these information.

    回复
  6. Enrique Kuamoo 说道：
    2012 年 2 月 2 日 19:53

    I and my colleagues watch the soccer game clips at YouTube always, for the reason that they have in pleasant quality.

    回复
  7. Tyrell Grebe 说道：
    2012 年 2 月 3 日 01:46

    I’d should verify with you here. Which is not something I often do! I take pleasure in studying a publish that may make people think. Additionally, thanks for permitting me to comment!

    回复
  8. Geoffrey Liefer 说道：
    2012 年 2 月 4 日 01:36

    If you are going for finest contents like myself, just visit this web page all the time as it provides quality contents, thanks

    回复
  9. Eric Napihaa 说道：
    2012 年 2 月 4 日 23:32

    All right you are right, in fact PHP is a open source and its assist we can take free from any discussion board or web page as it happens here at this website.

    回复

发表评论

电子邮件地址不会被公开。