How to append linq query for order by? RSS

• • Reply
  

  info2ambrish

  Member

  385 Points

  275 Posts

  How to append linq query for order by?

  May 04, 2012 12:18 PM|LINK

  Hi,

  I am using following query:

  var searchAppointment = from app in entities.Appointments
                                          join user in entities.Users on app.UserID equals user.UserID
                                          where app.AppointmentDate >= dtStartdate
                                          && app.AppointmentDate <= dtEnddate
                                          && user.UserName == userid
                                          //orderby app
                                          select app;

  i want to append query that sort based on First name ,LAst Name;

   searchAppointment = searchAppointment.OrderBy(Appointment => Appointment.PatientFirstName);
  searchAppointment = searchAppointment.OrderBy(Appointment => Appointment.PatientLastName);

  Pls give me solution.

  Thanks in advance
  
  
  

• • Reply
  

  Ramesh T

  Contributor

  5111 Points

  827 Posts

  Re: How to append linq query for order by?

  May 04, 2012 12:45 PM|LINK

  Try this

  var searchAppointment = from app in entities.Appointments
                                          join user in entities.Users on app.UserID equals user.UserID
                                          where app.AppointmentDate >= dtStartdate
                                          && app.AppointmentDate <= dtEnddate
                                          && user.UserName == userid
                                          orderby app.PatientFirstName, app.PatientLastName
                                          select app;

  
  
  

• • Reply
  

  info2ambrish

  Member

  385 Points

  275 Posts

  Re: How to append linq query for order by?

  May 04, 2012 12:49 PM|LINK

  Ramesh T

  Try this

  var searchAppointment = from app in entities.Appointments
                                          join user in entities.Users on app.UserID equals user.UserID
                                          where app.AppointmentDate >= dtStartdate
                                          && app.AppointmentDate <= dtEnddate
                                          && user.UserName == userid
                                          orderby app.PatientFirstName, app.PatientLastName
                                          select app;

  
  

  some time sort based on 

  PatientFirstName

  and some time

  PatientLastName

  not together both.

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: How to append linq query for order by?

  May 06, 2012 01:43 AM|LINK

  info2ambrish

  Ramesh T

  Try this

  var searchAppointment = from app in entities.Appointments
                                          join user in entities.Users on app.UserID equals user.UserID
                                          where app.AppointmentDate >= dtStartdate
                                          && app.AppointmentDate <= dtEnddate
                                          && user.UserName == userid
                                          orderby app.PatientFirstName, app.PatientLastName
                                          select app;

  Hello

  info2ambrish

  ：）

  Thanks for your quick reply and as far as I see，I think the answer I've referred above is right——it will sort first by FirstName，if the FirstName is the same，it will sort by LastName。

  So what actually it results in and what do you expect？

  Reguards！

  • Edited by decker dong - msft on May 06, 2012 01:43 AM
  • Marked as answer by info2ambrish on May 08, 2012 04:17 AM