Sample code for the Dapper Series of blog posts:

1. Loading an Object from SQL Server using Dapper

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)

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.

From the src\DapperSeries folder, build and run the app.

dotnet build
dotnet run

Using a tool like Postman, issue a post request to localhost:5000\api\db\init

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.

To execute the code for various API controllers, send get requests and see the results. For example, to query for the Aircraft with ID 42, send a get request to localhost:5000\api\aircraft\42\