skills.rest
filiptrivan
filiptrivanCOMMUNITY
Explore all skills by this author →
𝕏@filiptrivanGitHub

filtering-patterns

Implement server-side filtering and pagination for EF Core APIs with FilterDTO.

61|24|Updated Sep 14, 2024
Search Tags:#backend#filtering#pagination#efcore#filterdto#additionalfilterid
One-click install
npx skills add https://github.com/filiptrivan/spiderly --skill filtering-patterns
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: filtering-patterns
Source: https://github.com/filiptrivan/spiderly/tree/main/claude-plugins/skills/filtering-patterns
Command: npx skills add https://github.com/filiptrivan/spiderly --skill filtering-patterns

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Custom server-side filtering, pagination, and paginated list overrides tailor data access patterns for EF Core apps, enabling precise data delivery and performance.

Core Features & Use Cases

  • Override GetPaginated{Entity}List to pre-filter queries.
  • Use FilterDTO to build dynamic filters, sorts, and pagination.
  • Implement AdditionalFilterId for parent-child filtering.
  • Programmatic FilterDTO API patterns and custom projections for advanced DTOs.

Quick Start

Configure a GetPaginated{Entity}List override to apply FilterDTO-based filters and pagination.

Frequently Asked Questions about filtering-patterns

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I implement server-side filtering and pagination in EF Core APIs?▼

Override GetPaginated{Entity}List to pre-filter EF Core queries using FilterDTO structures for dynamic criteria and pagination, precisely tailoring data delivery for your APIs.

What is AdditionalFilterId used for in backend data filtering?▼

AdditionalFilterId is used for parent-child filtering, allowing backend APIs to apply hierarchical filter criteria across related data structures within the same query.

How do I build dynamic filter criteria programmatically for EF Core?▼

Build dynamic filter criteria programmatically using FilterDTO API patterns to construct custom projections and advanced DTOs, preserving base behaviors while applying dynamic sorts and pagination.

Can I override GetPaginated{Entity}List without losing base query behaviors?▼

Yes, overriding GetPaginated{Entity}List allows you to pre-filter queries and apply custom logic while preserving the base behaviors of the underlying data access patterns.

Does this approach support custom projections for advanced DTOs in EF Core?▼

Yes, the FilterDTO API patterns support custom projections, enabling the creation of advanced DTOs that map specific server-side filtered and paginated data structures.

Related Skills

Explore More Software Engineering Skills→
zenbuappszenbuapps

aibdd.auto.csharp.it.handlers.aggregate-given

Seeds initial aggregate state for Gherkin/BDD tests via EF Core DbContext.

Official
Advanced
genfeedaigenfeedai
2

serializer-boundary

Enforce centralized DTO serialization for API responses.

Official
Intermediate
nesbonesbo
53

bdd-dotnet

Implements BDD-style unit tests for .NET domain handlers using in-memory EF Core databases.

Community
Advanced
microsoftmicrosoft
19

migrating-linq-to-sql-to-ef-core

Migrate LINQ to SQL data access layers to Entity Framework Core.

Official
Advanced