The docs say this will work:

Dim sorter As New SortExpression(CustomerFields.Country Or SortOperator.Ascending) And _

            (CustomerFields.CompanyName Or SortOperator.Descending)

But we're trying to do this (Yes, the table names are real, but ignore that insanity)

Dim sort As New SortExpression

sort.Add(VwrHr180w8Fields.Clastname or SortOperator.Ascending) and (vwrhr180w8fields.cfirstname or sortoperator.ascending) and (vwrhr180w8fields.cmi or sortoperator.ascending)

The difference is that the docs suggest that adding multiple sort clauses is possible, at least in the constructor. I would think the same would be possible from the SortExpression.Add function.

Wutcha think?

Does it work for you if you call add multiple times?

The 'and' results in a new sortexpression, what you're doing isn't what's suggested in the docs. Which part of the docs are you referring to exactly?

Otis wrote:

The 'and' results in a new sortexpression, what you're doing isn't what's suggested in the docs. Which part of the docs are you referring to exactly?

Yes, if I call Add multiple times, it works. The docs don't even say I can do what I'm trying to do. It just seemed like it would be possible considering you can do the same thing with Predicates. The first example above is from the docs. The second block is my what I attempted (and failed) to do.

It's not that big of a deal.

BTW, jspaonocsi and I are both working on the same project for the same company so feel free to catagorize us as "That annoying CSI crowd"

Would you please try this:

Dim sort As New SortExpression
sort.Add((VwrHr180w8Fields.Clastname or SortOperator.Ascending) and (VwrHr180w8Fields.cfirstname or sortoperator.ascending) and (VwrHr180w8Fields.cmi or sortoperator.ascending))

Note the extra brackets.

Walaa wrote:

Would you please try this:

Dim sort As New SortExpression
sort.Add((VwrHr180w8Fields.Clastname or SortOperator.Ascending) and (VwrHr180w8Fields.cfirstname or sortoperator.ascending) and (VwrHr180w8Fields.cmi or sortoperator.ascending))

Note the extra brackets.

Sorry.

Error 2 Option Strict On disallows implicit conversions from 'SD.LLBLGen.Pro.ORMSupportClasses.SortExpression' to 'SD.LLBLGen.Pro.ORMSupportClasses.ISortClause'. 

This is someone else's response on our team so I don't have the liberty of attempting a cast.

Please use multiple Add() statements.