Search⌘ K
AI Features
Home
Courses
Building Web Applications with React and ASP.NET Core

Creating a Repository Method to Get Questions

Explore how to create a repository method that retrieves questions from a SQL database using Dapper. Understand best practices for managing database connections, executing stored procedures, and mapping query results to model classes to simplify data access in ASP.NET Core applications.

We'll cover the following...

Implementation of 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 Microsoft SQLc lient library, as well as Dapper:

Node.js
using Microsoft.Data.SqlClient;
using Dapper;

  1. In the GetQuestions method, overwrite the statement that throws a NotImplementedException by declaring a new database connection:

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

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

Note: A using block automatically disposes of the ...