skills.rest
FerranGuardia
FerranGuardiaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-server-dapper

Access SQL Server from .NET using Dapper with parameterized queries and transactions.

Updated Mar 2, 2026
Search Tags:#performance#data-access#dapper#sql-server#parameterized-queries#ado.net#net-framework
One-click install
npx skills add https://github.com/FerranGuardia/claude-autonomous-setup --skill sql-server-dapper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-server-dapper
Source: https://github.com/FerranGuardia/claude-autonomous-setup/tree/main/skills/backend/sql-server-dapper
Command: npx skills add https://github.com/FerranGuardia/claude-autonomous-setup --skill sql-server-dapper

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Streamlines robust data access to SQL Server from .NET apps using ADO.NET and Dapper, reducing boilerplate and boosting reliability.

Core Features & Use Cases

  • Parameterized queries with SqlParameter to prevent SQL injection and improve type safety.
  • Dapper-based data access for fast, lightweight object mapping and simple CRUD patterns.
  • Connection management and pooling best practices, including using using blocks and proper disposal.
  • Transactions and stored procedures support for complex business workflows, with safe rollback on errors.
  • Real-world use case: fetch product catalogs with minimal boilerplate and consistent mappings.

Quick Start

Run a quick example that opens a SqlConnection and retrieves data with Dapper.

Frequently Asked Questions about sql-server-dapper

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

FAQPage Schema
How do I use Dapper with SQL Server for fast data access in .NET?▼

Dapper with SQL Server streamlines robust data access from .NET apps by reducing boilerplate and boosting reliability. It provides fast, lightweight object mapping for simple CRUD patterns, ensuring high-performance read and write operations with minimal overhead.

How do I prevent SQL injection when running SQL Server queries in .NET?▼

Parameterized queries with SqlParameter prevent SQL injection and improve type safety in .NET. This approach ensures that user inputs are treated strictly as data values rather than executable code, securing your SQL Server data access operations.

What is the best way to manage SQL Server connections and pooling in a .NET application?▼

Connection management and pooling best practices involve using 'using' blocks for proper disposal of SqlConnection objects. This ensures efficient connection pooling, reducing overhead and maintaining high-performance data access to SQL Server.

Does this SQL Server data access approach support stored procedures and transactions?▼

Yes, this approach supports stored procedures and transactions for complex business workflows. It includes safe rollback on errors, ensuring data integrity during multi-step operations and reliable execution of your SQL Server logic.

Can I use Dapper for high-performance read and write operations in real-world .NET projects?▼

Dapper is applied to real-world projects needing high-performance read and write operations. It handles parameter mapping and transaction management efficiently, allowing you to fetch product catalogs with minimal boilerplate and consistent object mappings.

Related Skills

Explore More Software Engineering Skills→
diegoknskdiegoknsk
3

persistence-dapper-dotnet10

Standardize database persistence in .NET 8/10 applications using Dapper.

Community
Advanced
hung-phanhung-phan

connection-pooling

Configure and monitor SQL database connection pools to reduce connection overhead.

Community
Advanced
haipham22haipham22
2

golang-samber-do

Set up type-safe dependency injection for Go applications with samber/do v2.

Community
Advanced
microsoftmicrosoft
19

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

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

Official
Advanced