Working with the Infragistics grid and ES I can attempt to add a duplicate primary key and generate a database error. The grid itself might prevent this by design when bound to a keyed datatable, not sure, have not tried that yet.

WIth ES, what is the most efficient way to check the current collection does not contain the primary key combination that is about to be added?