Building Web Applications with React and ASP.NET Core/

...

/

Creating a Repository Method to Get a Single Question

Creating a Repository Method to Get a Single Question

Learn to create a repository method that retrieves a single question and its corresponding answers.

We'll cover the following...

Let’s implement the GetQuestion method now:

  1. Start by opening the connection and executing the Question_GetSingle stored procedure:

Press + to interact
public QuestionGetSingleResponse GetQuestion(int
questionId)
{
  using (var connection = new
    SqlConnection(_connectionString))
  {
    connection.Open();
    var question =
      connection.QueryFirstOrDefault<
        QuestionGetSingleResponse>(
        @"EXEC dbo.Question_GetSingle @QuestionId =
          @QuestionId",
        new { QuestionId = questionId }
      );
    // TODO - Get the answers for the question
    return question;
  }
}

This method is a little different from the previous methods because we are using the QueryFirstOrDefault Dapper method to return a single record (or null if the record isn’t found) rather than a collection of records.

    ...