SQL connection to Dapper/Asp.net Core

Question

I’m starting in Asp.net Core and I’m having difficulties to connect my Sql database. Below is my Model

My class of connection

appsetting.json

startup.Cs

Controller

Error shown when trying to execute

I already referenced Nuget with Dapper. Please help me understand where I am missing in connection with SQL.

Answer 1

If you look at the Asp.net core source code in https://github.com/aspnet/Extensions/blob/master/src/Configuration/Config.Abstractions/src/ConfigurationExtensions.cs

You may notice that the extension Getconnectionstring works as a shortcut for the section "ConnectionStrings", then change your appsettings.json to:

"ConnectionStrings": {
  "ConnectionLoja": ....
}

Tip: It’s interesting to publish the questions with the source code and not an image, it makes the answers easier.

Answer 2

Rafael’s tip already says a lot of what to do if using methods GetConnectionStrings, but if you need for some very specific reason use the Connectionstring from the configuration illustrated { Data : { ConnectionLoja: ...}, just use var dataLoja = configuration.GetSection("DataLoja").Get<DataLoja>();