I'm converting a console app into a WCF service and have hit a minor snag.
since there are more than 2500+ records to process and for each record I need to ensure the user initials in the list, loading the user through ensure user and the executing the query each time will definitely take a long time .
Is there a workaround to this?