Find Count using lambda Expression

Question

I have following classes:

public class Promotion
{
    public Offers Offers { get; set; }
}
public class Offers
{
   public List<PromotionOffer> Offer { get; set; }
}

public class PromotionOffer
{
    public string CategoryName { get; set; }
}

And I have an object of Promotion:

Promotion applicablePromotion = promotion;

applicablePromotion contains list of Offer and each offer has CategoryName. I want to find count where CategoryName == Package

Something like:

int count = applicablePromotion.Offers.Offer.Find(c => c.CategoryName == "Package").Count;

How can I do this?

What have your tried?

Pikoh
– Pikoh

2016-11-07 12:31:39 +00:00
Commented Nov 7, 2016 at 12:31 — Pikoh
– Pikoh, Commented Nov 7, 2016 at 12:31
Possible duplicate of SELECT COUNT in LINQ to SQL C#

SᴇM
– SᴇM

2016-11-07 12:37:33 +00:00
Commented Nov 7, 2016 at 12:37 — SᴇM
– SᴇM, Commented Nov 7, 2016 at 12:37

Felix D. · Accepted Answer · 2016-11-07 15:56:05Z

5

You could use:

var count = applicablePromotion.Offers.Offer.Count(o => o.CategoryName == "Package");

In LINQ the Count can accept a Lambda expression and you don't have to query with Where

Check it out here:

<iframe width="100%" height="475" src="https://dotnetfiddle.net/Widget/UKyWQJ" frameborder="0"></iframe>

edited Nov 7, 2016 at 15:56

Felix D.

5,2018 gold badges43 silver badges79 bronze badges

answered Nov 7, 2016 at 12:35

Bojan B

2,1214 gold badges20 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Farhad Jabiyev · Accepted Answer · 2016-11-07 12:36:58Z

3

You can use Where instead of Find:

int count = applicablePromotion.Offers
       .Offer
       .Where(x=> x.CategoryName == "Package")
       .Count();

edited Nov 7, 2016 at 12:36

Farhad Jabiyev

26.9k8 gold badges79 silver badges103 bronze badges

answered Nov 7, 2016 at 12:33

Eldaniz Ismayilov

8667 silver badges19 bronze badges

Comments

Csaba Benko · Accepted Answer · 2016-11-07 12:40:12Z

0

Shouldn't it be only:

int count = applicablePromotion.Offers.Find(c => c.CategoryName == "Package").Count;

I suppose Offers is your collection here, so you have to run Find on that.

answered Nov 7, 2016 at 12:40

Csaba Benko

1,1618 silver badges15 bronze badges

2 Comments

Bojan B Over a year ago

The Property Offers on the Promotion is not a collection but it contains the collection.

Csaba Benko Over a year ago

I yes, sorry I see. The naming was a little bit confusing for me. The original code then should just work fine I think. What is the probpem with it? What is the error message when we try to use it?

Collectives™ on Stack Overflow

Find Count using lambda Expression

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related