Convert SQL query to linq group by

Question

Converting SQL to linq

SQL:

select COUNT(ID), N_CNIC 
from dbo.GENRegistrations 
group by N_CNIC

I tried this:

Attempt #1:

return GEDdb.GENRegistrations 
            .GroupBy(x => x.N_CNIC)
            .Select(x => x.Key)
            .Count();

Attempt #2:

return GEDdb.GENRegistrations
            .GroupBy(x => new { x.ID, x.N_CNIC })
            .Select(g => new { idd = g.Key.ID, cnidc = g.Key.N_CNIC })
            .ToList();

Attempt #3:

return GEDdb.GENRegistrations
            .SqlQuery("select COUNT(ID) from dbo.GENRegistrations group by N_CNIC")
            .ToList();

Answer 1

Using regular query syntax:

var query =
    from x in GEDdb.GENRegistrations
    group 1 by x.N_CNIC into g
    select new
    {
        N_CNIC = g.Key,
        Count = g.Count(),
    };

Or using direct method calls:

var query = GEDdb.GENRegistrations
    .GroupBy(x => x.N_CNIC, _ => 1)
    .Select(g => new
    {
        N_CNIC = g.Key,
        Count = g.Count(),
    });