Wie lautet die Syntax für ORDERBY in LINQ von VB.NET?

Question

Ich bin neu in Linq, was ist die Syntax für Bestellung durch in VB?

Dim cxt As New datContext
Dim qry = (From lst In cxt.zipcodes _
              Select lst.state).Distinct

    qry = qry.OrderBy()

Meine einfache SQL-Anweisung wird wie folgt aussehen:

Select distinct state from zipcodes
order by State

Answer 1

qry = qry.OrderBy(Function(obj) obj.PropertyToSortBy)

Answer 2

Alternative Syntax für Ihre Anfrage (sauberer IMO):

Dim qry = From lst In cxt.zipcodes _
          Select lst.state Distinct _
          Order By state

Answer 3

Dim cxt As New datContext

Dim qry = (From lst In cxt.zipcodes OrderBy lst.state).Distinct.tolist

Dim statelst = qry.Select(Function(o) o.state).ToList