ASP.NET Core 3 and React

Creating a repository method to get questions by a search

Let's implement the GetQuestionsBySearch method, which is similar to the GetQuestions method, but this time, the method and stored procedure have a parameter. Let's carry out the following steps:

1. Start by creating and opening the connection in the same way as we did when we implemented the last method:

public IEnumerable<QuestionGetManyResponse> GetQuestionsBySearch(string search){  using (var connection = new SqlConnection(_connectionString))  {    connection.Open();    // TODO - execute Question_GetMany_BySearch stored procedure  }}

2. Now, we can execute the Question_GetMany_BySearch stored procedure:

public IEnumerable<QuestionGetManyResponse> GetQuestionsBySearch(string search) ...