Dapper Stored Procedure CRUD In MVC

Goal

This tutorial shows how to connect an MVC module to SQL Server through Dapper and stored procedures. The pattern is useful for enterprise-style applications that avoid Entity Framework.

Repository pattern

var command = new CommandDefinition("USP_M_CLIENT_MANAGE", parameters, commandType: CommandType.StoredProcedure);

Steps

1. Create table and stored procedure.
2. Create domain model and form view model.
3. Add repository methods.
4. Call the repository from a service.
5. Use the service from an MVC controller.