Linq distinct columns plus count from datatable : <p>Would like to pull a distinct list based on server name and resource group but provide a channel count as well. Datatable example:</p>

<pre><code>resourceGroup serverName    circuitId   channelId
SIP           win1234       0           1
SIP           win1234       0           2
TDM           win5678       0           35      
TDM           win5678       0           36
SIP           win5678       4           47
TDM           win1234       8           56
</code></pre>

<p>With the expected results:</p>

<pre><code>serverName  resourceGroup   channelCount
win1234     SIP             2
win1234     TDM             1
win5678     SIP             1
win5678     TDM             2
</code></pre>
