I am using a BO with multiple rows taken from the Database Table and want to ensure that I do not have any duplicates (On the BO) before I save.

If I was doing this against the database Table, I would issue someting like:

Select Country , Count(Country) as MyCount from MyTable Group by Country                 and then Test that myCount was not greater than 1

Is there any similar construct I can use for Business Object   i.e. be able to search through the BO and let it throw up any duplicates.

Did you read Paul's post? Or maybe I am misunderstanding what you are looking for.



This should copy only "distinct" rows from MyOtherBO to MyBO, based on the "DistinctColumn-ColumnName".

Hi Ivan. I am not seeing this. Maybe an example might clarify.

Say in the BO . I have following:



I want the duplicates in this (So that I can display an error message , as there should not be any duplicates) . So I want returned:-



(If I was doing this in Sql, I would use a Select Country ,Count(Country) as MyCount from Mytable Group by Country   (And anywhere MyCount > 1 are the duplicates)