DevForce Community Forum : orderby not working http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : orderby not working Sat, 11 Apr 2026 06:09:12 -700 Thu, 24 Sep 2009 11:40:39 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1491 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ orderby not working : Originally posted by tj62 I... http://www.ideablade.com/forum/forum_posts.asp?TID=1491&PID=5472#5472 Author: GregD
Subject: 1491
Posted: 24-Sep-2009 at 11:40am

Originally posted by tj62

I don't know if this is the right place for my question. If notplease advice me what is thr right forum for it.


Technically this is a LINQ question rather than a DevForce question, and you might get better answers on a LINQ forum somewhere.  But you can always ask. We (IdeaBlade staff) have to give priority to the DevForce questions, but sometimes we enjoy practicing our LINQ, too; and there are, of course, lots of other LINQ users on this forum who may help.

I believe the problem is that your query is ordering the entities -- whatever their type name -- coming out of EntPointGroupAccessSet rather than the Customers you ultimately project out. 

I created the following attempted analog of your query, targetting the NorthwindIB database that we ship with DevForce:

      var customerQ = (from od in _mgr.OrderDetails
                       where od.UnitPrice > 50
                       orderby od.Order.Customer.CompanyName
                       select od.Order.Customer).Distinct();

Like you, I get Customers not sorted by CompanyName.

But if I change the query to the following, I get the Customers sorted as desired:

      var customerQ = (from od in _mgr.OrderDetails
                    where od.UnitPrice > 50
                    select od.Order.Customer).Distinct()
                    .OrderBy(c => c.CompanyName);

The corresponding query with your types would look like this:

     var customerQ = (from c in _manager.EntPointGroupAccessSet
       where c.p_userID == "jhon"    
       select c.p_pointGroup.p_customer).Distinct()
       .OrderBy(cust=>cust.p_name);


]]> Thu, 24 Sep 2009 11:40:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1491&PID=5472#5472 orderby not working : Hi, I don't know if this... http://www.ideablade.com/forum/forum_posts.asp?TID=1491&PID=5467#5467 Author: tj62
Subject: 1491
Posted: 24-Sep-2009 at 1:57am

Hi,
I don't know if this is the right place for my question. If not please advice me what is thr right forum for it. I'm quite a newby in LINQ but with long experience with SQL...so I'm having a small learning curver barrier here.

I have a LINQ to entities query using navigation properties that is such:

var customerQ = (from c in _manager.EntPointGroupAccessSet

where c.p_userID == "jhon"

orderby c.p_pointGroup.p_customer.p_name

select c.p_pointGroup.p_customer).Distinct();

foreach( EntCustomer c in customerQ )

{

    Console.WriteLine( "Customer = " + c.p_name );

    Console.WriteLine();

}

This query is working perfectly except the orderby is not working the data output is unordered. Why is the orderby cluse ignored?
How can I modify the query to get the order by working?
]]> Thu, 24 Sep 2009 01:57:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1491&PID=5467#5467