DevForce Community Forum : Silverlight: Dynamic OrderBy

Silverlight: Dynamic OrderBy : Well, I used the term "test"...

Thu, 29 Jul 2010 10:43:41 -700

Author: kimj
Subject: 2001
Posted: 29-Jul-2010 at 10:43am

Well, I used the term "test" quite loosely - I ran a single query and it worked. Here's the query -
     var customersQuery = _em1.Customers
        .Where(c => c.ContactTitle == "Sales Representative")
        .OrderBy("CompanyName")
        as EntityQuery;

      _em1.ExecuteQueryAsync(customersQuery, GotCustomers, null);

The changes to the DynamicLibrary were hacks, just to see if the code would compile. I'll post it here, but I want to emphasize this is neither tested nor endorsed by IdeaBlade, and certainly not supported - it's just my hacking to try the DL in Silverlight.

uploads/11/DynamicLibrary.cs.txt

Silverlight: Dynamic OrderBy : Do you have the code that you...

Thu, 29 Jul 2010 09:24:53 -700

Author: jkowalski
Subject: 2001
Posted: 29-Jul-2010 at 9:24am

Do you have the code that you test with?

Thanks for the info. I'll give it a try.

Silverlight: Dynamic OrderBy : Actually, some of it does. The...

Tue, 27 Jul 2010 08:46:08 -700

Author: kimj
Subject: 2001
Posted: 27-Jul-2010 at 8:46am

Actually, some of it does. The ClassFactory does not work in Silverlight, along with the CreateClass methods on DynamicExpression, but if you remove or comment all that out you can get the DynamicLibrary working. I only tested the dynamic OrderBy so don't know what else might fail at run time, but this library is pretty handy.

Silverlight: Dynamic OrderBy : FYI: This does not work with Silverlight...

Mon, 26 Jul 2010 12:34:16 -700

Author: jkowalski
Subject: 2001
Posted: 26-Jul-2010 at 12:34pm

FYI: This does not work with Silverlight

Silverlight: Dynamic OrderBy : found it. Will this work with...

Fri, 23 Jul 2010 16:31:16 -700

Author: jkowalski
Subject: 2001
Posted: 23-Jul-2010 at 4:31pm

found it.

Will this work with Silverlight?

Silverlight: Dynamic OrderBy : Sorry but the link is no good....

Fri, 23 Jul 2010 15:59:52 -700

Author: jkowalski
Subject: 2001
Posted: 23-Jul-2010 at 3:59pm

Sorry but the link is no good.

Edited by jkowalski - 23-Jul-2010 at 4:00pm

Silverlight: Dynamic OrderBy : You might find something here: LINQ...

Fri, 23 Jul 2010 15:45:03 -700

Author: GregD
Subject: 2001
Posted: 23-Jul-2010 at 3:45pm

You might find something here:

LINQ Dynamic Query Library

Silverlight: Dynamic OrderBy : There has got to be a better...

Fri, 23 Jul 2010 13:04:33 -700

Author: jkowalski
Subject: 2001
Posted: 23-Jul-2010 at 1:04pm

There has got to be a better way to dynamically order a Silverlight Blade query.

Please advise.

var accounts = (IEntityQuery<Account>)accountQuery;

var orderedQuery = accounts.OrderBy(a => a.AccountName);

if(DefaultSortDirection == ListSortDirection.Ascending)

{

switch (DefaultSortColumn.ToLower())

{

case "accountname":

orderedQuery = accounts.OrderBy(a => a.AccountName);

break;

case "accountid":

orderedQuery = accounts.OrderBy(a => a.AccountID);

break;

case "accountsubtype":

orderedQuery = accounts.OrderBy(a => a.AccountSubtype);

break;

case "accounttype":

orderedQuery = accounts.OrderBy(a => a.AccountType);

break;

case "address1":

orderedQuery = accounts.OrderBy(a => a.Address1);

break;

}

else

{

switch (DefaultSortColumn.ToLower())

{

case "accountname":

orderedQuery = accounts.OrderByDescending(a => a.AccountName);

break;

case "accountid":

orderedQuery = accounts.OrderByDescending(a => a.AccountID);

break;

case "accountsubtype":

orderedQuery = accounts.OrderByDescending(a => a.AccountSubtype);

break;

case "accounttype":

orderedQuery = accounts.OrderByDescending(a => a.AccountType);

break;

case "address1":

orderedQuery = accounts.OrderByDescending(a => a.Address1);

break;

}

return orderedQuery;