Entity Framework removing entitdades that has fk

Question

Asked 10 years, 4 months ago

Viewed 27 times

1

I have in my Repospository, my method of deleting

public virtual void Deletar(int Id)
{
  var entity = _dbSet.Find(Id);
  _dbSet.Remove(entity);
}

The problem is that it is deleting even if it is with FK in another table, and I don’t want it to delete, which is wrong?

You have to create database contraints. There is no magic. Or else validate via application, which is also not simple.

– Fernando Leal

2014/09/17 at 13:50
Fernando, when generating the bank (code first) is already generated with FK

– Rod

2014/09/17 at 14:09
Which database you use?

– Fernando Leal

2014/09/17 at 14:15
Sql Server 2012

– Rod

2014/09/17 at 14:24
It was to generate an exception in the database if there is the correct Constraint.

– Fernando Leal

2014/09/17 at 14:30
Fernando, I found the bug already, was in a configuration of the Entity Framework

– Rod

2014/09/17 at 14:31

1 answer

Browser other questions tagged entity-framework-6

You are not signed in. Login or sign up in order to post.

by Rod • **9,412** points · Answer 1 · 2014-09-17T14:32:37+00:00

By default, the Entity framework comes with Cascade enabled, so I disabled it and it went on my Exception

  modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();