Adding Select Top in a Statement from a controller of ASP.net MVC 3

Question

a question on how to add a "SELECT TOP" query in asp.net mvc3

            var applicant = from s in applicantRepository.GetApplicant()
                       select s;

in my applicant there is i think 200,000 datas and i just want to select the top 50

is that possible? Thanks KUDOS! :)

von v. · Accepted Answer · 2013-05-06 07:02:22Z

2

To return the top 50 rows in any order

var applicant = 
    (from s in applicantRepository.GetApplicant()
    select s).Take(50);

if you want to apply ordering, say there's a LastName field

var applicant = 
    (from s in applicantRepository.GetApplicant()
    orderby s.LastName
    select s).Take(50);

answered May 6, 2013 at 7:02

von v.

17.1k5 gold badges62 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JleruOHeP · Accepted Answer · 2013-05-06 07:04:05Z

2

Use Take and Skip accordingly. For example, to take second 10 applicants:

var applicant = 
  (from s in applicantRepository.GetApplicant()
   select s).Skip(10).Take(10);

answered May 6, 2013 at 7:04

JleruOHeP

10.4k4 gold badges49 silver badges77 bronze badges

Santosh Panda · Accepted Answer · 2013-05-06 07:04:13Z

1

Use the Take extension method:

var applicant = (from s in applicantRepository.GetApplicant()
                       select s).Take(50);

answered May 6, 2013 at 7:04

Santosh Panda

7,3418 gold badges45 silver badges58 bronze badges