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?

  • Are users are different in each list.
    – Aanchal
    Commented May 19, 2014 at 5:31
  • yes, each list item corresponds to a user
    – Aman Gupta
    Commented May 19, 2014 at 5:32

1 Answer 1


You can first query the list with distinct users in the list and create/ensure that users.

So you don't need to query for every listitem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.