Write C# LINQ queries for filtering, grouping, joining, and aggregating data.
npx skills add https://github.com/TheBushidoCollective/han --skill csharp-linq
Please help me install this Agent Skill. Skill: csharp-linq Source: https://github.com/TheBushidoCollective/han/tree/main/jutsu/jutsu-csharp/csharp-linq Command: npx skills add https://github.com/TheBushidoCollective/han --skill csharp-linq
This Skill teaches querying with Language Integrated Query (LINQ) in C#, covering both query and method syntax, including deferred execution and common patterns.
Write a small C# snippet that queries a list of people to find adults and project their names.
High-intent search queries and answers about installing and using this skill.
LINQ provides type-safe querying across collections, databases, and XML sources using query or method syntax. Filter with Where, transform with Select, and chain operations to express complex data transformations while maintaining compile-time type checking.
Query syntax resembles SQL and reads declaratively (from x in collection select x.Name), while method syntax chains extension methods (collection.Select(x => x.Name)). Both compile to identical IL; choose based on readability and team preference.
Use GroupBy to partition collections by key and produce grouped results. Use Join for inner joins across collections, or GroupJoin for left-join-like patterns that preserve all items from the outer collection with grouped matches.
LINQ queries execute lazily until materialized—ToList(), ToArray(), or iteration triggers evaluation. Deferred execution enables composable queries and avoids unnecessary computation, but reuses enumeration sources and can mask side effects.
LINQ extends beyond in-memory collections to LINQ to SQL, Entity Framework for databases, and LINQ to XML for document querying. Expression trees translate LINQ syntax into database queries or XPath, preserving type safety across data sources.
Filter early with Where before projections, avoid repeated enumeration, materialize large intermediate results selectively, and leverage database providers to push filtering and aggregation server-side instead of in-memory processing.
RyoMurakami1983Integrate Oracle Database connectivity into .NET WPF applications with repository pattern and ORA-* error handling.
aws-samplesProcess and analyze CSV, JSON, and text data files with automated cleaning and transformation.
dolsoonBuild C# 13 backend applications with .NET 9 and ASP.NET Core.
snowdamizExplain Mesh programming language syntax for functions, closures, pipe operators, and control flow.
