How to catch daughter entities from a data constraint?

Question

Well my problem is this, I need to bring a bank entity and it contains several lists that should bring your data following a rule, the field data_exclusao must be void.

All entities have the field data_exclusao which represents the logical deletion of the data. Then follows an example to get better I have the entity person and it contains the lists of entities endereco and phone. When I go to fetch the person entity from the bank it should bring all the addresses and telephones where the data_exclusao is equal to null.

I use the EF and I would like to know where I apply this rule so that it is generic, that is, all searches of the database always bring the data where the field data_exclusao is equal to null.

Observing: The data model through the EDMX and the version of EF what use is the EF6.

Answer 1

The Way to Circumvent a Feature Not So Far in the Version Entity Farmework 6.2.0 is using the packets:

• Z.EntityFramework.Plus.EF6
• Z.EntityFramework.Plus.QueryIncludeFilter.EF6

With these two packages is added the feature in filter automatically in all SQL of the entities configured to run filters Global.

A minimal example:

Entity:

public partial class Funcionario
{
    public int Id { get; set; }
    public string Nome { get; set; }
    public DateTime? DataExclusao { get; set; }
}

How will it all work SQL where the Global filter is DataExclusao IS NULL, then to work add the namespace:

using Z.EntityFramework.Plus;

in the Builder of his class who inherits from the DbContext, writes that line of code:

this.Filter<Funcionario>(x => x.Where(a => a.DataExclusao == null));

Complete code:

public partial class DatabaseContext : DbContext
{
    public DatabaseContext()
        :base(@"Data Source=.\SqlExpress; ...")
    {
        this.Filter<Funcionario>(x => x.Where(a => a.DataExclusao == null));
    }
    public virtual DbSet<Funcionario> Funcionario { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Funcionario>()
            .ToTable("Funcionario");

        modelBuilder.Entity<Funcionario>()
            .Property(e => e.DataExclusao).HasColumnType("datetime");

        modelBuilder.Entity<Funcionario>()
            .Property(e => e.Nome)
                .IsRequired()
                .HasMaxLength(50)
                .IsUnicode(false);
    }
}

After this setting, instate the class and use it as an example:

using (DatabaseContext db = new DatabaseContext())
{
    var c = db.Funcionario.ToArray();
}

to SQL which has been debugged is as follows::

SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[Nome] AS [Nome], 
    [Extent1].[DataExclusao] AS [DataExclusao]
    FROM [dbo].[Funcionario] AS [Extent1]
    WHERE [Extent1].[DataExclusao] IS NULL

If you don’t want to use filters at some point in your code, use the extension method AsNoFilter(), example:

var c = db.Funcionario.AsNoFilter().ToArray();

_{Other examples:}

• bring menus and active submenus C#
• How to create default filters with Entity framework 6?

_References

• Z.EntityFramework.Plus.EF6 - Query Filter
• Z.EntityFramework.Plus.EF6
• Z.EntityFramework.Plus.QueryIncludeFilter.EF6