>>>>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?
I'm dealing with this right now, too. I know they have their job to do and they're definitely not evil, but they really slow down the development flow of the project.