How to write insert if not exist else update using entity framework?

Question

I have multiple string values, I want to insert in an sql server db table, But i want to check values one by one if it already exist in the db I will update, if not I will insert it.

I am using Entity Framework 4.1, and I hope I can do that with best performance, means less calls to db as I can.

I saw this question before, but they are using linq to sql not entity framework.

Joel Martinez · Accepted Answer · 2011-10-20 19:58:58Z

3

One way you could do it is to batch up the queries for existence ... for example, using the .Contains method (like this), you can query for some or all of the items which may or may not exist at once. Then once you have the data locally, you can quickly check if it's there before inserting

answered Oct 20, 2011 at 19:58

Joel Martinez

47.9k26 gold badges136 silver badges186 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write insert if not exist else update using entity framework?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related