Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using AddOrUpdate from System.Data.Entity.Migrations
Message
 
To
All
General information
Forum:
ASP.NET
Category:
Entity Framework
Title:
Using AddOrUpdate from System.Data.Entity.Migrations
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:
01598293
Views:
49
We're having a debate about whether to use EF AddOrUpdate.

According to Julie Lerman at http://thedatafarm.com/data-access/take-care-with-ef-4-3-addorupdate-method/ you should only use AddOrUpdate when doing Data Migrations during development.

My co-workers are saying that using AddOrUpdate is acceptable even though it makes a round trip query to the database to see if the record exists in order to determine whether it creates an update or an insert command. I've seen that in SQL Profiler.

And Julie makes other arguments against its use as well.

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform