Get minimum value in linq query

Question

I'm using Entity Framework for my DB access.

One of the entities is Products, and a Product can have many Terms.

Here's the Term class:

public partial class Term
{
    public short ID { get; set; }
    public short ProductID { get; set; }
    public byte TermSegmentID { get; set; }
    public byte MinTerm { get; set; }
    public byte MaxTerm { get; set; }


    public virtual Product Product { get; set; }
}

Having selected a list of all my products, I've been trying to return the minimum value in MinTerm - that's the lowest value for all Products, not each one.

Can anyone help? This is proving difficult for my limited knowledge.

Thanks in advance.

Selman Genç · Accepted Answer · 2014-10-10 14:45:57Z

1

This should do what you want:

byte minTerm = yourProducts.SelectMany(x => x.Terms).Min(x => x.MinTerm);

answered Oct 10, 2014 at 14:45

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

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

Comments

Jon Skeet · Accepted Answer · 2014-10-10 14:45:53Z

0

Does Product have a Terms property? If so, it's pretty easy:

var minMinTerm = products.SelectMany(product => product.Terms)
                         .Min(term => term.MinTerm);

The SelectMany method "flattens" a sequence - so you end up with a single sequence of terms, logically the concatenation of each of the terms sequences from the products.

answered Oct 10, 2014 at 14:45

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Collectives™ on Stack Overflow

Get minimum value in linq query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related