C# MVC get .Distinct() data

I have some data in SQL Server:

[
  {
    "code": 1,
    "name": "qweee",
    "IDNO": "ff2222"
  },
  {
    "code": 2,
    "name": "test2",
    "IDNO": "ff2222211"
  },
  {
    "code": 3,
    "name": "fsdfasdf",
    "IDNO": "ddaaa"
  },
  {
    "code": 4,
    "name": "qweee",
    "IDNO": "ff2222"
  },
  {
    "code": 5,
    "name": "123",
    "IDNO": "U120000005"
  }
]

I need to use the following SQL in C # MVC

SELECT DISTINCT  
    A1.IDNO , A1.name ,
    (SELECT COUNT(cnt_tab.IDNO) 
     FROM Postpartum_AccountsManagement AS cnt_tab
     WHERE cnt_tab.IDNO = A1.IDNO) AS data_cnt
FROM 
    Postpartum_AccountsManagement AS A1

Then I will get

[
      {
        "name": "test2",
        "IDNO": "ff2222211",
        "data_cnt": 1
      },
      {
        "name": "qweee",
        "IDNO": "ff2222",
        "data_cnt": 2
      },
      {
        "name": "fsdfasdf",
        "IDNO": "ddaaa",
        "data_cnt": 1
      },
      {
        "name": "123",
        "IDNO": "U120000005",
        "data_cnt": 1
      }
]

I need to get the same data in C# MVC.

Click here view more answers http://ift.tt/1KG77bK