Creating insert and update methods using entityframework

Question

1.00/5 (2 votes)

See more:

we have table(A) with Three columns in that
one is primary key(A) (auto increment) identity and remaining two are foreign keys(both are auto increment).
i am inserting and editing based on primary key(auto increment) is it correct?
if not how to write insert and update statements using entity framework?

What I have tried:

C#

public void InsOrUpdate(int id, int pid, int cId)
        {
            var cP = _uoW.Com.FindBy(CP => CP.Id == id).FirstOrDefault();
            if (cP != null)
            {
                cP.Id = id;
                cP.PId = pId;
                cP.CId = cId;
                _uoW.Com.Edit(cP);
            }
            else
            {
                cP=new Comp();
                cP.Id = id;
                cP.PId = pid;
                cP.CId = cId;
                _uoW.Com.Add(cP);
            }
            _uoW.SaveChanges();
        }

Posted 8-Sep-16 4:00am

Member 11712712

Updated 8-Sep-16 6:17am

Maciej Los

v3

Add a Solution

Comments

Maciej Los 8-Sep-16 10:59am

Does it working? If yes, it is correct insert/edit statement for entity framework.
;)

Vincent Maverick Durano 8-Sep-16 15:32pm

perhaps this would help: http://www.c-sharpcorner.com/article/entity-framework-basic-guide-to-perform-fetch-filter-insert-update-and-dele/

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nathan Minier · Answer 1 · 2016-09-08T06:17:00

So, you have a couple of options here. I have a tip on this very issue, and a robust answer:
Generic Entity Framework AddOrUpdate Method with Composite Key Support[^]

Now, if all you want is basic support for one single table that will just update a couple of values, you can do the following:

C#

public void InsOrUpdate(int id, int pid, int cId)
        {
            var cP = _uoW.Com.Find(id); // DbSet.Find works really well
            if (cP != null) //there is no need to try and set the Id. We already have it.
            {
                cP.PId = pId;
                cP.CId = cId;
                _uoW.Entry(cP).State = EntityState.Modified; // Here's the secret sauce
            }
            else
            {
                cP=new Comp //the cool kids use object initializers
                {
                   Id = id;
                   PId = pid;
                   CId = cId;
                };
                _uoW.Entry(cP).State = EntityState.Added;
            }
            _uoW.SaveChanges();
        }

Creating insert and update methods using entityframework

1 solution

Solution 1

Add your solution here

Preview 0

Creating insert and update methods using entityframework

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us