Entity Framework 6 - Knowledge Base (KB)

Using sql server compact edition to insert OR update (upsert).

I have c# project that is using sqlserver compact edition and entity framework for data access. I have the need to insert or update a large amount of rows, 5000+ or more to the db, so if the key exists update the record if not insert it. I can not find ...

How can I use use Entity Framework to do a MERGE when I don't know if the record exists?

In ...this SO answer... about Entity Framework and MERGE, the example for how to code it is this:...public void SaveOrUpdate(MyEntity entity) { if (entity.Id == 0) { context.MyEntities.AddObject(entity); } else { context.MyEntities.Attac...

Entity Framework - UPSERT on unique indexes

I searched a bit regarding my problem but can't find anything that really to help....So my problem/dilema stays like this: I know that mysql database have a unique index system that can be used for insert/update in same query using this format: ...insert ...