PaginationFilter
Im Moment hat der PaginationFilter mehrere Probleme:
warn: Microsoft.EntityFrameworkCore.Query[10102] Query: '(from AccountEntity entity in DbSet where (from KeyValuePair<string, string> filter ...' uses a row limiting operation (Skip/Take) without OrderBy which may lead to unpredictable results.
warn: Microsoft.EntityFrameworkCore.Query[20500] The LINQ expression 'where {__selector_Filter_0 => All(FilterPredicate(__properties_1, [entity], [filter]))}' could not be translated and will be evaluated locally.
warn: Microsoft.EntityFrameworkCore.Query[20500] The LINQ expression 'All(FilterPredicate(__properties_1, [entity], [filter]))' could not be translated and will be evaluated locally.
warn: Microsoft.EntityFrameworkCore.Query[20500] The LINQ expression 'Skip(__p_2)' could not be translated and will be evaluated locally.
warn: Microsoft.EntityFrameworkCore.Query[20500] The LINQ expression 'Take(__p_3)' could not be translated and will be evaluated locally.
Unterscheidung zwischen Pagination/Order (Default Order einbauen) und Filter (welche nach SQL translated werden kann).
Lokale evaluation sollte ganz vermieden werden!