Converting query to Lambda Expression

Question

In mysql,

select distinct(trim(containerType)) from productIn where containerType <> '' group by containerNo

How can I make expression that query using Lambda?

Ex)

List<string> containerTypes = new List<string>();
containerTypes = productInRepository.GroupBy(x=> x.containerNo).Select(?????).ToList();

enter image description here

It's been a while since I've done MySql, but is your SQL even legal? A select on a field not included in the group by? — Anthony Pegram
– Anthony Pegram, Commented Nov 15, 2012 at 5:15

Dima · Accepted Answer · 2012-11-15 05:30:13Z

1

I think groupby field which is not in result select means the same as orderby this field.

List<string> containerTypes = productInRepository
                .Where(x => x.containerType != string.Empty)
                .OrderBy(x => x.containerNo)
                .Select(x => x.containerType.Trim())
                .Distinct();

answered Nov 15, 2012 at 5:30

Dima

6,7414 gold badges26 silver badges43 bronze badges

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

Comments

Spencer Ruport · Accepted Answer · 2012-11-15 05:15:35Z

1

List<string> containerTypes = productInRepository
    .Where(x => x.containerType != string.Empty)
    .GroupBy(x=> x.containerNo)
    .Select(x => x.containerType.Trim())
    .ToList();

answered Nov 15, 2012 at 5:15

Spencer Ruport

35.2k12 gold badges89 silver badges150 bronze badges

Collectives™ on Stack Overflow

Converting query to Lambda Expression

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