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！