dapper

USE FOR: High-performance SQL queries mapped to POCOs, read-heavy and latency-critical data access, stored procedure invocation, multi-mapping joins, bulk operations, and scenarios requiring full SQL control. DO NOT USE FOR: Schema migrations (use EF Core or FluentMigrator), complex object-graph change tracking, or applications where a full ORM with lazy loading is needed.

跳到安装

仓库: Tyler-R-Kendrick/agent-skills
最近来源活动: 2026年2月11日 05:14
检测到的 SKILL.md 语言: 英语
星标: 10
分支: 4

安装方式

默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。

用 Codex 或 Claude 帮你安装复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。

直接命令不会经过审查 Prompt；运行前请先检查来源。

npx skills add https://github.com/Tyler-R-Kendrick/agent-skills --skill dapper

命令会保持在同一行。复制前请横向滚动并检查完整内容。

想先保存到本地？可下载 SkillsMP 当前能够提供的文件。

检查来源文件

决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。

文件资源管理器

16 个文件

SKILL.md

来源说明 · 只读预览

返回搜索返回安装

improve

Use when producing agent/LLM evals, synthetic simulation data, or self-improvement pipelines for prompts, code, skills, agents, harnesses, and workflows. Covers AgentEvals/AgentV, Agent Skills evals, ASSERT, GEPA, Trace, VISTA, Agent Lightning, SkillOpt, Simula-style data design, progressive disclosure, deterministic workspaces, and release evidence. USE FOR: eval creation, EVAL.yaml, AgentEvals, AgentV, evals.json, ASSERT, judge-traces, behavior taxonomy, judges, graders, rubrics, synthetic data, simulation data, Simula, QDC, source-grounded generation, prompt optimization, agent improvement, skill improvement, harness hardening, progressive disclosure, deterministic workflows, GEPA, Trace, VISTA, Agent Lightning, SkillOpt DO NOT USE FOR: ordinary unit/integration tests without AI quality criteria (use testing), refactoring without eval or trace feedback (use refactor), generic Agent Skills packaging without eval or improvement work (use agent-skills)

2026-06-09

Use when working with AI agent protocols, standards, interoperability specifications, evaluation contracts, synthetic simulation data, improvement pipelines, and agent steering workflows. Covers MCP, A2A, ACP, Agent Skills, AGENTS.md, ADL, Improve, x402, AP2, MCP Apps, cagent, and learn. USE FOR: agent protocol selection, comparing MCP vs A2A vs ACP, understanding agent standards ecosystem, choosing payment protocols, choosing eval standards, choosing improvement techniques, choosing synthetic data simulation techniques, steering from user feedback DO NOT USE FOR: specific protocol, eval, or improvement implementation details (use the sub-skills: mcp, a2a, acp, improve, learn, x402, etc.)

2026-06-09

learn

Use when a user corrects, rejects, edits, or redirects an LLM/agent response and the correction should become a reusable reasoning strategy. Converts feedback into generalized learnings for ~/.agents/STEERING.md with linked RDF/Turtle evidence. USE FOR: user corrections, preference feedback, rejected agent behavior, reasoning strategy updates, steering file maintenance DO NOT USE FOR: storing task facts (use memory), ordinary skill authoring (use agent-skills), project instruction files unrelated to feedback (use agents-md)

2026-06-08

查看这个仓库的全部 Skills

name	dapper
description	USE FOR: High-performance SQL queries mapped to POCOs, read-heavy and latency-critical data access, stored procedure invocation, multi-mapping joins, bulk operations, and scenarios requiring full SQL control. DO NOT USE FOR: Schema migrations (use EF Core or FluentMigrator), complex object-graph change tracking, or applications where a full ORM with lazy loading is needed.
license	MIT
metadata	{"displayName":"Dapper","author":"Tyler-R-Kendrick","version":"1.0.0"}
compatibility	["claude","copilot","cursor"]
references	[{"title":"Dapper GitHub Repository","url":"https://github.com/DapperLib/Dapper"},{"title":"Dapper NuGet Package","url":"https://www.nuget.org/packages/Dapper"},{"title":"Dapper Documentation","url":"https://www.learndapper.com/"}]

Dapper

Overview

Dapper is a lightweight, high-performance micro-ORM for .NET that extends IDbConnection with methods for executing SQL and mapping results to strongly-typed objects. It does not generate SQL, manage change tracking, or handle migrations -- it maps query results to POCOs with minimal overhead. Dapper is used when you need full control over SQL, maximum query performance, or when working with legacy databases where an ORM's conventions do not fit.

using System.Data; using Dapper; using Microsoft.Data.SqlClient; public sealed class ProductRepository { private readonly string _connectionString; public ProductRepository(string connectionString) { _connectionString = connectionString; } public async Task<IReadOnlyList<Product>> GetAllAsync(CancellationToken ct) { using IDbConnection db = new SqlConnection(_connectionString); var products = await db.QueryAsync<Product>( "SELECT Id, Name, Price, CategoryId FROM Products ORDER BY Name"); return products.AsList(); } public async Task<Product?> GetByIdAsync(int id, CancellationToken ct) { using IDbConnection db = new SqlConnection(_connectionString); return await db.QuerySingleOrDefaultAsync<Product>( "SELECT Id, Name, Price, CategoryId FROM Products WHERE Id = @Id", new { Id = id }); } public async Task<int> CreateAsync(Product product, CancellationToken ct) { using IDbConnection db = new SqlConnection(_connectionString); return await db.ExecuteScalarAsync<int>( @"INSERT INTO Products (Name, Price, CategoryId) VALUES (@Name, @Price, @CategoryId); SELECT SCOPE_IDENTITY();", new { product.Name, product.Price, product.CategoryId }); } public async Task<bool> UpdateAsync(Product product, CancellationToken ct) { using IDbConnection db = new SqlConnection(_connectionString); int rowsAffected = await db.ExecuteAsync( @"UPDATE Products SET Name = @Name, Price = @Price, CategoryId = @CategoryId WHERE Id = @Id", new { product.Id, product.Name, product.Price, product.CategoryId }); return rowsAffected > 0; } } public sealed class Product { public int Id { get; set; } public string Name { get; set; } = string.Empty; public decimal Price { get; set; } public int CategoryId { get; set; } }

Aspect	Dapper	Entity Framework Core
SQL control	Full (you write SQL)	Generated (LINQ to SQL)
Performance	Fastest (near raw ADO.NET)	Good (with optimization)
Change tracking	None	Built-in
Migrations	None	Built-in
Learning curve	Low (just SQL + mapping)	Medium (LINQ, conventions)
Best for	Read-heavy, reports, legacy DBs	CRUD, complex domains

dapper

安装方式

检查来源文件

Dapper

Overview

Dapper

Overview

Basic Query and Command

Multi-Mapping (Joins)

Stored Procedures

Multiple Result Sets

Transaction Support

DI Registration Pattern

Dapper vs Entity Framework Core

Best Practices

dapper

来源信息

安装方式

检查来源文件

同仓库更多 Skills

同仓库更多 Skills

Dapper

Overview

Dapper

Overview

Basic Query and Command

Multi-Mapping (Joins)

Stored Procedures

Multiple Result Sets

Transaction Support

DI Registration Pattern

Dapper vs Entity Framework Core

Best Practices