If I have a self servicing collection i.e.:

CountryCollection(0).States

Can I assign a SortClause to the states before iterating thorugh it.

i.e.

CountryCollection(0).States.SortClause = MySortClause?

When I do this, the SortClause doesn't take effect. Rather, I need to call GetMulti with a sort?

Any way to avoid this? It just seems cleaner if I can assign the SortClause directly.

Thanks!

You mean you want to sort it in Memory?

You may use the collection Sort() methog.

CountryCollection(0).States.Sort(...);

Walaa wrote:

You mean you want to sort it in Memory?

You may use the collection Sort() methog.

CountryCollection(0).States.Sort(...);

I was hoping to do it server side on the SQL server :-)

mshe wrote:

Walaa wrote:

You mean you want to sort it in Memory?

You may use the collection Sort() methog.

CountryCollection(0).States.Sort(...);

I was hoping to do it server side on the SQL server :-)

We thought you wanted in-memory sorting

And yes, I think that is possible... I never used this before, but I tested today and seems to work very well:

CustomerEntity myCustomer = new CustomerEntity("ALFKI");

// creating the sorter
SortExpression sorterToOrders = new SortExpression();
sorterToOrders .Add(OrdersFields.Freight | SortOperator.Ascending);

// specifications for the sorting of the resultset. When not specified, no sorting is applied. 
customer.SetCollectionParametersOrders(0, sorterToOrders );

// orders sorted...
customer.Orders

daelmo wrote:

CustomerEntity myCustomer = new CustomerEntity("ALFKI");

// creating the sorter
SortExpression sorterToOrders = new SortExpression();
sorterToOrders .Add(OrdersFields.Freight | SortOperator.Ascending);

// specifications for the sorting of the resultset. When not specified, no sorting is applied. 
customer.SetCollectionParametersOrders(0, sorterToOrders );

// orders sorted...
customer.Orders

The SortClause just seemed to obvious, so that's the secret! SetCollectionParametersEntity. Thanks!