'Random' Orderby in webservice using LINQ To Entities

Question

Morning all

Now I know there is a reason to this odering but my tiny little brain can't get my head around it.

I am using a webservice to pull through data to a webp[age and have the following that is so far pulling data through from UUF1:

 public string[] GetBuyer(string Memberkey) { try { WebService.EntitiesConnection buyer = new WebService.EntitiesConnection(); return buyer.tblProducts .Where(p => p.MemberId == Memberkey) .OrderBy(p => p.UnitUserfield1) .Select(p => p.UnitUserfield1) .Distinct() .ToArray(); } catch (Exception) { return null; } }

This works fine and pulls the data through but in a strange order. Where I would expect results of A B C D E F, it appears to be returning A C E B D F.

Could someone point out the error in my ways please?

Coding Flow · Accepted Answer · 2010-06-01 11:45:47Z

1

Do your OrderBy last, i have seen this before with LinqToSql, having the OrderBy before the Distinct caused it to generate SQL with no OrderBy in it.

answered Jun 1, 2010 at 11:45

Coding Flow

21.9k6 gold badges68 silver badges84 bronze badges

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

3 Comments

MrDean Over a year ago

I have tried that but when implementing this, I receive " 'string' does not contain a definition for 'UnitUserfield1' and no extension method 'Unitiuserfield1' accepting a first argument of type 'string' could be found" error. I'm not sure how to tackle that bad boy.

Coding Flow Over a year ago

Your dealing with an IEnumerable<string> collection by then so just do .OrderBy(p => p);

MrDean Over a year ago

Top, top man...thank you Ben. For anyone wanting the final code: return buyer.tblProducts .Where(p => p.MemberId == Memberkey) .Select(p => p.UnitUserfield1) .Distinct() .OrderBy(p => p) .ToArray();

MrDean · Accepted Answer · 2010-06-01 12:20:31Z

Top, top man...thank you Ben. For anyone wanting the final code:

 return buyer.tblProducts .Where(p => p.MemberId == Memberkey) .Select(p => p.UnitUserfield1) .Distinct() .OrderBy(p => p) .ToArray();`

Collectives™ on Stack Overflow

'Random' Orderby in webservice using LINQ To Entities

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related