Entity Framework adding record with a related object

Question

We have the following AddUser method which adds a new record to the database using EF:

    public User AddUser(User user)
    {
        using (var context = DataObjectFactory.CreateContext())
        {
            var userEntity = Mapper.Map(user);

            context.AddObject("UserEntities", userEntity);

            context.SaveChanges();

            return Mapper.Map(userEntity);
        }
    }

Our User type is like this:

public class User
{
    public string FirstName { get; set; }

    public string LastName { get; set; }

    public Customer Customer { get; set; }     
}

We have a Customer table and a User table and in User table we have customerid as a foreign key.

In the USER table we have Firstname, Lastname and CustomerId fields, we get the firstname, lastname and customerid (dropdown list of customers) details from the user, create the Customer object with customerid we get from the user and pass all of these to the AddUser method, but what happens is that the User gets inserted into the database and also a new Customer is inserted into the Customer's table (with a new customerid), is there any way of stopping this?

Thanks

podiluska · Accepted Answer · 2012-09-28 09:58:44Z

2

You need to set the EntityState of the Customer to Unchanged.

Something like

 context.Entry<Customer>(customer).State = EntityState.Unchanged;

or

 context.ObjectStateManager.ChangeObjectState(userEntity.Customer, EntityState.Unchanged);

(depending on what kind of context you are using)

See http://msdn.microsoft.com/en-us/data/jj592676.aspx

edited Sep 28, 2012 at 9:58

answered Sep 28, 2012 at 9:53

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework adding record with a related object

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