Entity Framework Delete Entity without its Dependency

Question

While I am trying to delete my entity I am getting following error in my function;

A relationship from the 'ProjectWebsiteTag_ProjectUser' AssociationSet is in the 'Deleted' state. Given multiplicity constraints, a corresponding 'ProjectWebsiteTag_ProjectUser_Target' must also in the 'Deleted' state.

Here is my code to delete;

public bool Delete(int id)
        {
            try
            {
                using (ProjectDataContext context = new ProjectDataContext())
                {

                    ProjectWebsiteTag websiteTag = context.WebsiteTags.FirstOrDefault(p => p.WebsiteTagId == id);
                    context.WebsiteTags.Remove(websiteTag);
                    int saveChanges = context.SaveChanges();
                    return saveChanges > 0;
                }
            }
            catch (DbEntityValidationException e)
            {
                FormattedDbEntityValidationException newException = new FormattedDbEntityValidationException(e);
                throw newException;
            }
        }

Here is my data class;

public class ProjectWebsiteTag
    {
        public int WebsiteTagId { get; set; }
        public ProjectUser ProjectUser { get; set; }
        public ProjectWebsite ProjectWebsite { get; set; }           
    }

My Config Class;

 public ProjectWebsiteTagConfiguration()
        {
            ToTable("ProjectWebsiteTags");
            HasKey(p => p.WebsiteTagId);
            HasRequired(p => p.ProjectUser).WithRequiredDependent().WillCascadeOnDelete(false);
            HasRequired(p => p.ProjectWebsite).WithRequiredDependent().WillCascadeOnDelete(false);
        }

It looks like it is trying to delete User record, but I do not want that. I just want to delete "ProjectWebsiteTag" and that's it.

What I am missing here?

It doesn't seem to be a case of cascade deleting, it's trying to ADD a user with null values in non-nullable fields — Rob
– Rob ♦, Commented Jul 6, 2015 at 3:29
@Rob Why it would even do that? I am not even intending to pull user entity from context. — Teoman shipahi
– Teoman shipahi, Commented Jul 6, 2015 at 3:34

Jon Brian Skog · Accepted Answer · 2015-07-06 03:50:56Z

1

It isn't trying to delete the ProjectUser. It's trying to insert it. ProjectWebsiteTagConfiguration() is saying that the ProjectWebsiteTags table has a ProjectUser foreign key in it. When you call

ProjectWebsiteTag websiteTag = context.WebsiteTags.FirstOrDefault(p => p.WebsiteTagId == id)

websiteTag has a ProjectUser with an empty string for its UserId property. So either the record in the ProjectWebsiteTags table has an empty string for the foreign key, or EF is newing a ProjectUser (with an empty UserId) when you get from the context. Either way, EF isn't aware of the existence of a ProjectUser with an empty string id, so when you call SaveChanges() it tries to add it. It can't because the UserId field is required and empty.

answered Jul 6, 2015 at 3:50

Jon Brian Skog

1616 bronze badges

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

1 Comment

Teoman shipahi Over a year ago

You're right. I was initializing User object inside ProjectWebsiteTag constructor. I removed that initialization. Meanwhile, I am getting different error now. I updated the question. Thanks for the hint.

Teoman shipahi · Accepted Answer · 2015-07-06 04:45:48Z

0

I had to fix my problem by adding one-to-many relationship configuration in my User class. It comes to a resolution of I need to add relationship hint on both sides of Configuration declarations.

public class ProjectUserConfiguration : EntityTypeConfiguration<ProjectUser>
    {
        public ProjectUserConfiguration()
        {
            ToTable("ProjectUsers");
            HasKey(p => p.UserId);
            HasMany(p=>p.ProjectWebsiteTags).WithRequired(q=>q.ProjectUser).WillCascadeOnDelete(false);
        }
    }

answered Jul 6, 2015 at 4:45

Teoman shipahi

23.5k16 gold badges147 silver badges175 bronze badges

Collectives™ on Stack Overflow

Entity Framework Delete Entity without its Dependency

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related