public async Task <Adjective> ReadRandomAsync()
{
int count = await _session.Select <Adjective>().CountAll().From().ScalarAsync <int>();
int offset = HelperService.GetRandomNumber(0, count);
Adjective adj = await _session.SelectAllFrom <Adjective>().OrderBy(x => x.Value).Limit(offset, 1).FirstOrDefaultAsync();
return(adj);
}
public async Task <Noun> ReadRandomAsync()
{
try
{
int count = await _session.Select <Noun>().CountAll().From().ScalarAsync <int>();
int offset = HelperService.GetRandomNumber(0, count);
Noun noun = await _session.SelectAllFrom <Noun>().OrderBy(x => x.Value).Limit(offset, 1).FirstOrDefaultAsync();
return(noun);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}