I do a search for a property in our CRM system and extract the results into a datatable.
If the datatable is = 0 then I exception as the property does not exist.
If the datatable is = 1 we have found the property.
If the datatable is > 1 then i need to do more validation for example add the property’s tenant surname until we only find one result. If i still find more than 1 then it’s a business exception.