public async Task <ActionResult <IEnumerable <Records> > > GetAllRecords()
{
// System.Console.WriteLine("GET**************************************************************");
// var records = _context.Records.
// FromSqlRaw("SELECT COUNT(comments.id)" +
// "FROM comments,records " +
// "WHERE comments.fk_record = records.id " +
// "GROUP BY records.id;").ToList();
// foreach (var record in records)
// {
// System.Console.WriteLine("{0}", record);
// }
// List<Records> records = await _context.Records.ToListAsync();
// foreach (var item in records)
// {
// System.Console.WriteLine(_context.Records.FromSqlRaw("SELECT {id} FROM praktika.records;", item.Id));
// }
// var records = await _context.Records.ToListAsync();
// var comments = await _context.Comments.ToListAsync();
// foreach (var record in records)
// {
// int i = 0;
// foreach (var comment in comments)
// {
// if (comment.FkRecord == record.Id)
// {
// i++;
// }
// }
// record.CommentsNr = i;
// _context.Entry(record).State = EntityState.Modified;
// }
var recordsList = await _context.Records.Include("Comments").ToListAsync();
var convertedList = Records.ConvertList(recordsList);
return(convertedList);//await _context.Records.Include("Comments").ToListAsync();
}
