Database

Stored Procedure CRUD Checklist

A quick checklist for action-based SQL Server stored procedures used with Dapper repositories.

Beginner 12 min read By Prakash Kumar Sahoo Updated 23 May 2026 SQL Server Dapper
SQL Server Stored Procedures Dapper CRUD
Learning progress Not started Your progress is saved in this browser.
Stored Procedure CRUD Checklist
Published23 May 2026
Updated23 May 2026
LevelBeginner
Reading12 min

Checklist

Use consistent actions such as INSERT, UPDATE, DELETE, GETBYID, GETALL, and GETACTIVE.

Parameters

@Action NVARCHAR(40), @Id BIGINT = 0, @ActorId BIGINT = NULL

Reminder

Always include audit fields, soft delete behavior, and predictable result sets for Dapper mapping.

Quick feedback Was this helpful? Your feedback is saved in this browser.

Keep Learning

Related note content.

Checklist

MVC Module Checklist

A quick checklist for planning MVC modules before implementation.

10 min read Open
Security

Cookie Authentication Checklist

A quick revision checklist for cookie authentication, claims, login paths, role authorization, session timeout, and secure logout.

12 min read Open
Frontend

jQuery AJAX Form Checklist

A quick checklist for AJAX forms: prevent duplicate submit, serialize fields, handle validation errors, show loading states, and reset safely.

10 min read Open