>>>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.
>>
>>
>>What's the reason for not permitting sprocs?
>>
>>SQL Server itself executes system stored procs all the time for different database operations. Does your employer block SQL Server system stored procs? :)
>>
>>Your employer doesn't seem to have a problem with EF generating SQL code that you really can't adjust (at least not without some very intricate workarounds).
>>
>>I realize you're working under constraints and might not have any power to change them. But the EF is not the "end all".
>
>Kevin,
>
>Thanks for your response. But, sprocs are a forbidden word here and I'm just the part-time night janitor apprentice with a mop and a bucket. Gosh, that kinda conjures up Fantasia, doesn't it?

Overly Possessive DBA Syndrome?