Sample code for the Dapper Series of blog posts:
The sample project for this series of blog posts is an ASP.NET Core project containing api controllers. To test the project you will issue GET and POST to the api.
.NET Core SDK v2.1.4 or newer A SQL Server database (Localdb or any modern version of SQL Server will work fine)
Creating a new database
The sample can be used to create a new database with some sample data. The default setting is to use localdb. If you do not have localdb installed, change the connection string in applicationSettings.json to point to an instance of SQL Server on your machine.
src\DapperSeries folder, build and run the app.
dotnet build dotnet run
Using a tool like Postman, issue a post request to
A database containing tables and sample data should be created. If everything worked as expected, you will receive a 200 OK result. If not, you should get some HTML that will have an error buried in it somewhere.