Help with composing async Task<IEnumerable<variables>> .....

Question

User-507786106 posted

I must select distinct values from one column named YEAR from the database table.  I MUST use async Task<IEnumerable<variables>> for this code in my class library.

I need help with the body of the code in the class library. The goal is to return a list of Distinct Years from the database table.

Code - need linq code.

public async Task<IEnumerable<mClerkTbl>> GetFiscalYearList()

{

      return await _mClerkTblRepository....... <-- HELP!!!

}

Answer 1

User-474980206 posted

old school:

var result = await dbContext.TheTable
     .GroupBy(r => r.Year)
     .Select(grp => grp.FirstOrDefault())
     .ToListAsync();

modern:

var result = await dbContext.TheTable 
     .Select(r => r.Year) 
     .Distinct()
     .ToListAsync();

Answer 2

User-507786106 posted

Great job and thanks so much.  It worked perfectly!!!!