Print Page | Close Window

orderby not working

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1491
Printed Date: 05-Apr-2025 at 11:08am


Topic: orderby not working
Posted By: tj62
Subject: orderby not working
Date 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?


Replies:
Posted By: GregD
Date 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 not please 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);


Print Page | Close Window