Blazor + Syncfusion + Dapper: Part 3 - Dapper C# Code Generation

Create a C# Blazor application using Syncfusion controls and Dapper to illustrate a one-to-many relationship (master/detail pages). This video explains how to use Alan Simpson's code generator application to create SQL stored procedures and C# code for model, services and interface classes.
Full description, code and documentation for the project at: blazorcode.uk/countriesandcit...
Background: Alan Simpson's Blazor CRUD videos: www.youtube.com/watch?v=XsCfa...
Alan Simpson's Code Generator Application for Dapper RUclips: • Blazor + Dapper Code G...
Alan Simpson's Code Generator Application for Dapper Github: github.com/AlanSimpsonMe/
Syncfusion: www.syncfusion.com

[@DigitalNomadOnFIRE]

Why are you using Stored Procedures? I haven't used those for years and it's not required with Dapper, far easier to just use parameters.

[@christopherbell7186]

Personal preference I guess. If the backend database is SQLite, then stored procedures cannot be used, so for flexibility stored procedures should be avoided - but I still like them!

[@DotnetistEnterprise]

whats the Dapper Code Generator?

[@christopherbell7186]

A C# application written by Alan Simpson that creates SQL scripts for stored procedures, and C# code for model, service and interface classes. See the links in the Description

[@DotnetistEnterprise]

@@christopherbell7186 ahh nice.. I've created something like that as well. but will check what it is.

[@DigitalNomadOnFIRE]

IMHO class names should be singular not plural.

[@christopherbell7186]

Point taken.