skills.rest
pengdows
pengdowsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

pengdows-crud

Provide SQL-first, strongly-typed data access for .NET with CRUD and transaction control.

8|Updated Jun 22, 2025
Search Tags:#sql#dotnet#data-access#tablegateway#sqlcontainer
One-click install
npx skills add https://github.com/pengdows/pengdows.crud --skill pengdows-crud
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pengdows-crud
Source: https://github.com/pengdows/pengdows.crud/tree/main/.gemini/skills/pengdows-crud
Command: npx skills add https://github.com/pengdows/pengdows.crud --skill pengdows-crud

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

pengdows.crud solves the boilerplate and rigidity of traditional data access by providing a SQL-first, strongly-typed layer for .NET that gives explicit control over queries, mappings, and transactions.

Core Features & Use Cases

  • Strongly-typed TableGateway, SqlContainer, and DatabaseContext for CRUD, business-key retrieval, and concurrency management
  • Multi-database support with dialect-aware SQL generation, batching, and safe transaction handling, plus testing with FakeDb
  • Clear three-tier API: Build (SQL generation), Load (execution), and Retrieve (convenience methods) with DI-friendly singleton gateways

Quick Start

Create and wire a TableGateway for your entity, then perform CRUD operations against your configured database.

Frequently Asked Questions about pengdows-crud

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

FAQPage Schema
How do I build strongly-typed CRUD operations in .NET without an ORM?▼

Multi-database support in .NET is handled through dialect-aware SQL generation within a SQL-first data access layer, allowing safe transaction handling and batching across different database providers using the same strongly-typed gateway structure.

What is the best way to manage optimistic concurrency and transactions in .NET data access?▼

Optimistic concurrency and safe transaction handling in .NET data access are managed through strongly-typed DatabaseContext and TableGateway components, ensuring explicit SQL control and concurrency management during CRUD operations.

How do I test .NET data access logic without connecting to a real database?▼

Testing .NET data access logic without a live database is done using FakeDb, allowing you to validate CRUD operations, entity mapping, and SQL generation logic from the gateway components in isolated unit tests.

Does this SQL-first .NET data access layer support dependency injection?▼

Yes, dependency injection is supported through DI-friendly singleton gateways, allowing you to cleanly wire and resolve strongly-typed TableGateway, SqlContainer, and DatabaseContext instances within your .NET application pipeline.

How do I execute raw SQL queries with strongly-typed entity mapping in .NET?▼

Raw SQL queries with strongly-typed entity mapping in .NET are executed using a three-tier API—Build for SQL generation, Load for execution, and Retrieve for convenience methods—ensuring explicit control over the query and mapping process.

Related Skills

Explore More Software Engineering Skills→
JeffallanJeffallan
10.9k

C# Developer

Design and implement .NET 8+ C# applications with ASP.NET Core APIs, Blazor, and EF Core.

Community
Intermediate
codexyzdevcodexyzdev

prisma-transactions

Provide REST and GraphQL APIs with token authentication and interactive documentation.

Community
Advanced
ovachieverovachiever
52

neon-vercel-postgres

Configure and debug serverless Postgres connections for Neon or Vercel Postgres in edge runtimes.

Community
Advanced
nettenette
41

nette-database

Map database tables to typed Row entities in Nette Database with Explorer.

Official
Advanced