Doing a DataTable.Select() in ADO.NET is like using a Where clause in T-SQL, but you’d have noticed that Data table lacks a way to retrieve only specific number of rows. Well this can be easy to work around using a Top N clause in T-SQL but can be tricky in case when the data is read from different sources like XML files, Web Services etc.
Steven Smith shows a little code-snippet that can be used to work around this, so I decided to use that.
I went a step ahead and added the method to my Extension methods library as below.
So for example it can be used as follows.