Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using AddOrUpdate from System.Data.Entity.Migrations
Message
From
08/04/2014 16:51:07
 
General information
Forum:
ASP.NET
Category:
Entity Framework
Environment versions
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01598293
Message ID:
01598311
Views:
33
Likes (1)
>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".
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform