I am trying to get data for a chart using var getData = await _context.WOMains.Where(s => s.OrgID == orgid).Select(s => s.WOType).ToListAsync(); foreach (var item in getData) { WOMainChart = getData.Select(a => new WOChart { ChartData = item, ChartValue = item.Count() }).ToList(); } In the table I have three disting WOType, each added only one time, so 3 rows in total. However, when I run the query I get 22 as a count for each. What am I doing wrong?

Hi Marius, You need to do group by count for your type, Please refer below one https://stackoverflow.com/questions/11564311/sql-to-entity-framework-count-group-by

Thank you Kiran, DistinctBy is not present, I only have Distinct. Jignesh solution is perfect

Thank you, it is working fine. I found that answer with my friend google but I was confused by ChartData = s.Key, ChartValue = s.Count() because I was not finding my WOType

Hi, Mostly you are getting duplicate records . Please try as below var getData = await _context.WOMains.Where(s => s.OrgID == orgid).Distinct(s => s.WOType).ToListAsync();

Answers

asp.net core ef count rows containing a specific data

Marius Vasile

2.4k

I am trying to get data for a chart using

var getData = await _context.WOMains.Where(s => s.OrgID == orgid).Select(s => s.WOType).ToListAsync();
foreach (var item in getData)
{
WOMainChart = getData.Select(a => new WOChart
{
ChartData = item,
ChartValue = item.Count()
}).ToList();
}

In the table I have three disting WOType, each added only one time, so 3 rows in total. However, when I run the query I get 22 as a count for each. What am I doing wrong?