ASP.NET Core 3 and React

Creating a repository method to get questions

Let's implement the GetQuestions method first:

1. Let's add a couple of using statements at the top of the file for the ADO.NET SQL client library as well as Dapper:

using System.Data.SqlClient;using Dapper;

2. Let's declare a new database connection:

public IEnumerable<QuestionGetManyResponse> GetQuestions(){ using (var connection = new SqlConnection(_connectionString))  {   }}

Notice that we've used a using block to declare the database connection.

A using block automatically disposes of the object defined in the block when the program exits the scope of the block. This includes whether a return statement is invoked within the block as well as errors occurring within the block.

So, the using statement ...