De-dupe API
Need a class library to be built using C# (4.0) and Dynamic Linq to achieve the following functionality. Please do not use any DataTable, DataView to achieve this, only use Dynamic Linq.
Functionality:
Take a DataTable and as per columns specified and output criteria, data should be filtered and returned in a new DataTable.
Input :
1. DataTable ([login to view URL])
2. Column criteria (single column or multiple column or all
columns) List<string>
3. Output Criteria (Unique rows/ Duplicate rows) enum
Output: DataTable ([login to view URL])
Example: if column criteria is one column, find all unique rows for all that column and all duplicate rows for that column and so on for multiple columns
Required:
1. Clean code
2. Comments
3. Use of abstract or interfaces where necessary
4. Should be able to handle 1 million rows (not worried about
time, but no memory leaks please)
5. Please try to keep it simple
6. No need to get into threading in class library as it adds overload