How do I write LINQ to query against a Dataset for the below query.
select [Column 0], [Column 9] from [TABLE_1]
where [Column 0] = 'NY'
group by [Column 0], [Column 9]
My table contains records like:
[Column 0], [Column 9]
NY aaa
NY aaa
NY bbb
WI ccc
The target is to get after running the query, but using LINQ:
[Column 0], [Column 9]
NY aaa
NY bbb
Thanks,
select [Column 0], [Column 9] from [TABLE_1]
where [Column 0] = 'NY'
group by [Column 0], [Column 9]
My table contains records like:
[Column 0], [Column 9]
NY aaa
NY aaa
NY bbb
WI ccc
The target is to get after running the query, but using LINQ:
[Column 0], [Column 9]
NY aaa
NY bbb
Thanks,