.Net MVC Select top 20/ Take(20)

Remark : Mssql 쿼리 top 20 개만 가져오기


var applicant = 
    (from s in MyRepository.GetApplicant()
    orderby s.LastName
    select s).Take(10);

var applicant =

(from s in MyRepository.GetApplicant()

orderby s.LastName

select s).Take(10);


        public async Task<IActionResult> History(int? id)
        {
            if (id == null)
            {
                return NotFound();
            }

            var Rule_History = from s in _context.Historys
                               select s;

            return PartialView(await History.AsNoTracking().Where(s => s.IDX == id).Take(20).ToListAsync());
        }

public async Task<IActionResult> History(int? id)

{

if (id == null)

{

return NotFound();

}

var Rule_History = from s in _context.Historys

select s;

return PartialView(await History.AsNoTracking().Where(s => s.IDX == id).Take(20).ToListAsync());

}