Will the OrderBY for an IQuerable be executed in the Database or in the application server RSS

• • Reply
  

  johnjohn1231...

  Participant

  922 Points

  871 Posts

  Will the OrderBY for an IQuerable be executed in the Database or in the application server

  May 10, 2012 10:11 PM|LINK

  i have the following on my action method:-

  var result = repository.visitsearch(datefrom, dateto, CountryID).OrderByDescending(d => d.VisitDate).ToList();

  which calls the following repository.visitsearch method:-

   public IQueryable<VisitSearch> visitsearch(DateTime? datefrom, DateTime? dateto, int countryid)
              {
                  
                  var vs = (from v in entities.Visits
                         //code goes here....
                  return vs;

  My question is :- will the OrderByDescending(d => d.VisitDate) on my action method be executed on the database level OR in the application server???

  BR

  • Edited by johnjohn123123 on May 10, 2012 10:12 PM
  • Edited by johnjohn123123 on May 10, 2012 10:13 PM
• • Reply
  

  ignatandrei

  All-Star

  134913 Points

  21619 Posts

  Moderator

  MVP

  Re: Will the OrderBY for an IQuerable be executed in the Database or in the application server

  May 10, 2012 10:19 PM|LINK

  johnjohn123123

  Will the OrderBY for an IQuerable be executed in the Database or in the application server

  Database.

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
  • Marked as answer by johnjohn123123 on May 10, 2012 10:23 PM