Coder Csharp Efcore Queries

What it does

This skill allows AI agents to generate and execute Entity Framework Core (EFCore) queries in C#. It can retrieve data from a database based on specified criteria, perform filtering, sorting, and joins. The agent will construct the query string and then execute it against a configured EFCore context.

When to use it

• Data Retrieval: You need to fetch specific records from a database table based on certain conditions (e.g., "Get all customers in California").
• Report Generation: You want to extract data for creating reports or dashboards, requiring complex filtering and aggregation.
• Application Logic: Your application requires querying the database as part of its core functionality (e.g., retrieving product details based on a user's search).
• Data Analysis: You need to analyze data stored in a relational database using C# queries.

Key capabilities

• Generates EFCore query strings.
• Executes generated queries against an EFCore context.
• Supports filtering, sorting and joins.
• Retrieves data from the database.

Example prompts

• "Write an EF Core query to get all products with a price greater than $50."
• "Generate a C# query using Entity Framework Core to find orders placed in the last week."
• “Create an EF Core query that joins Customers and Orders tables to retrieve customer names and their corresponding order counts.”

Tips & gotchas

• Requires a configured EFCore context with appropriate database connection details. The agent needs access to this context to execute queries successfully.