>I agree with Naomi and Kevin. Don't do this at the application layer.

I really don't understand what you all are proposing. Are you saying to use SPROCs instead of EF? So, your responses don't help me at all in convincing these people not to use EF's AddOrUpdate which comes from the Migrations namespace.

Using SPROCs: That's not going to happen. People here will not permit us to use SPROCs even when I've made a case to use them instead of very complicated LINQ.

Also, SQL Profiler shows that the SQL generated by EF 6.02 or whatever is the latest is not using Merge. It's using either an Insert or an Update.