I have the following dataset and would like to count and display values of distinct rows based on 2 columns.
Input
WOID WOPID STAFFID
WO01 WOP01 ST001
WO01 WOP02 ST001
WO02 WOP03 ST002
WO03 WOP04 ST003
Desired Output
WOID COUNT
WO01 2
WO02 1
WO03 1
May I know how can this be achieved using c# LINQ?
