How to ensure the item only uses once in parallel foreach loop?

Have you considered two loops?

One for inserts and one for updates.

---

Hope that helps

Please don't forget to up vote answers you like or which help you and mark one(s) which answer your question.