What's the syntax for ORDERBY in VB.NET's LINQ?

Question

I'm new to Linq, what's the syntax for orderby in VB?

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

    qry = qry.OrderBy()

my simple sql statement will be like this:

Select distinct state from zipcodes
order by State

Answer 1

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

Answer 2

thanks, that works!!!

Here's my final statement: Dim qry = (From lst In cxt.zipcodes _ Select lst.state).Distinct.OrderBy(Function(state) state)

Answer 3

Alternative syntax for your query (cleaner IMO):

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