How to insert update multiple data in DB through Entity Framework

Question

Suppose I have few records which i want to insert/update through EF.

public partial class Contact
{
        public int ContactID { get; set; }
        public string ContactPerson { get; set; }
        public string EmailID { get; set; }
}

var _Contact = new list<Contact>();
_Contact.add(new Contact(){ContactID=1,ContactPerson="Dev",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=2,ContactPerson="Ross",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=3,ContactPerson="Martin",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=4,ContactPerson="Moss",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=5,ContactPerson="Koos",EmailID="[email protected]"});

With the help of a stored procedure, we can detect that any particular records exist or not, if exist then update will execute and if not exist then records will be inserted. i want to do the same through EF.......is it possible ?

I know that I can call SQL Server stored procedures from EF to achieve my goal but I am trying to know if I can do it in EF without calling a stored procedure?

If yes then discuss the same with sample code which check each records exist in db or not and if exist then it will update otherwise will insert. Looking for help.

How do you check that record already exists in DB? What is equality for records, ContactID? — Aleksandr Ivanov
– Aleksandr Ivanov, Commented Jul 22, 2014 at 14:39
possible duplicate of How do I upsert a record in ADO.NET EF 4.1? — Matthew Haugen
– Matthew Haugen, Commented Jul 22, 2014 at 14:43

codeworx · Accepted Answer · 2014-07-22 15:13:25Z

1

Since EF 4.3 there is an AddOrUpdate ExtensionMethod for DbSet. in Namespace System.Data.Entity.Migrations

public partial class Contact
{
    public int ContactID { get; set; }
    public string ContactPerson { get; set; }
    public string EmailID { get; set; }
}

var _Contact=new list<Contact>();
_Contact.add(new Contact(){ContactID=1,ContactPerson="Dev",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=2,ContactPerson="Ross",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=3,ContactPerson="Martin",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=4,ContactPerson="Moss",EmailID="[email protected]"});
_Contact.add(new Contact(){ContactID=5,ContactPerson="Koos",EmailID="[email protected]"});

// check by Primary key
context.Contacts.AddOrUpdate(_Contacts)
// or check by EmailID
context.Contacts.AddOrUpdate(p => p.EmailID, _Contacts)

answered Jul 22, 2014 at 15:13

codeworx

2,74515 silver badges12 bronze badges

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

3 Comments

Thomas Over a year ago

thanks for your answer but if i need to see what SQL AddOrUpdate() will generate then how do i know? suppose without using SQL server profiler how can i hook AddOrUpdate() function in code which write or dupm the sql to console generate by AddOrUpdate() function....any idea??

Thomas Over a year ago

is there any site which show the feature added in EF version wise. suppose AddOrUpdate() added in EF version 4.3. so what other feature has been introduce in prev or next version in EF. i want site which show or discuss EF related feature version wise with example code & details. please guide if u have any idea. thanks

Thomas Over a year ago

plzz see this code. / check by Primary key context.Contacts.AddOrUpdate(_Contacts) u said it would check by PK but if there is more than one PK i mean composite PK is there...the how it will handle?

Collectives™ on Stack Overflow

How to insert update multiple data in DB through Entity Framework

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related