This contains a sample project using both Dapper & AutoMapper using .Net Core 3.1 and VB.Net.
The SQL folder contains a couple of T-SQL scripts. The scripts creates tables & data used in the example. (I used SQL Server 2019 Dev Ed.)
There is also a script that will convert the tables into VB Classes. If you want to play with the system, add fields to a table then just replace the Class starting with
e.g. <Table XXXX> ... End Class
Use output of the script's query window. I used SSMS to do this.
PLEASE NOTE THIS IS NOT INTENDED TO BE BEST PRACTICES BUT RATHER REMIND ME HOW I GOT THINGS WORKING.