How to delete data from one table related to another

Question

I have the following situation with a method of deleting directory:

internal void DeleteDiretorio(Model.Diretorio diretorio)
    {
        using (var ctx = new TESTEntities())
        {
            var dir = ctx.DIRETORIO.FirstOrDefault(a => a.DIRETORIO_GUID == diretorio.DIRETORIO_GUID);
            if (dir == null)
                throw new ArquivoException("Diretorio não encontrado");
            ctx.Entry(dir).State = System.Data.EntityState.Deleted;
            ctx.SaveChanges();

        }

    }

This method is to delete according to the id,but Directory it has a list of files so it does not allow to delete, as would be this method in EF to delete with all files linked to the directory?

Answer 1

In your entity classes, in the navigation objects, just use Data Annotation [Required], as in the example below:

public class Produto
{
    public int Id { get; set; }
    public string Nome { get; set; }

    [Required]
    public Categoria Categoria { get; set; }
}

If you are using mapping with Entitytypeconfiguration, you can use Willcascadeondelete:

HasRequired(t => t.Categoria)
  .WithMany(m => m.Produtos)
  .HasForeignKey(d => d.id)
  .WillCascadeOnDelete(true);