Global Query Filter

[Burgyn]

In many cases, we want to define a global filter to apply to each query. For example: IsDeleted = false, ParentId = 1, UserId = ActiveUser.Id, etc.

It would be great to be able to define it in one place and KORM would automatically add this condition to every query.

public class DatabaseConfiguration : DatabaseConfigurationBase
{
    public override void OnModelCreating(ModelConfigurationBuilder modelBuilder)
    {
        modelBuilder.Entity<Document>()
            .UseQueryFilter(entity => entity.IsDeleted == false && entity.ParentId == 1);
    }
}

KORM will automatically add a condition ((IsDeleted = 0) AND (ParentId = 1) when calling any query using Query<Document>().

It should be possible to do this in all scenarios except for direct sql calls _database.Query<Document>().Sql("SELECT * FROM DOCUMENT");

Ignoring global filters

If I need to call a query without these conditions, I must explicitly say:

_database.Query<Document>()
    .IgnoreQueryFilters()
    .ToList();

Things to think about

• We can have multiple classes to retrieve data from the same table. For example: DocumentHeader, DocumentVerySpecialDto, etc. It would be nice to define this filter for all these classes.

• Create prototype

• Allow append where to existing where

• Configuration

• Add necessery information into query provider

• Use defined filter

• Ignore query filter

• Unit and integration tests

• Xml comments

• Information to readme file.

• Add info into KORM.MsAccess. (Constructor of QueryProvider was changed).