Developing Applications with ASP.NET Core/

...

/

Solution: Implement Custom Query with Repository

Solution: Implement Custom Query with Repository

This lesson covers the solution to implementing a custom query with a repository.

We'll cover the following...

Solution

The solution to the challenge is provided below. Feel free to explore the following files:

  • IUserRepo.cs
  • Startup.cs
  • MockUserRepo.cs
  • /Controllers/Api/UsersController.cs
  • SqlUserRepo.cs
using System;
using System.Collections.Generic;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using People.Data;
using People.Models;

namespace People.Controllers.Api
{
    [Route("api/[controller]")]
    [ApiController]
    public class UsersController : ControllerBase
    {
        private readonly IUserRepo _user;

        public UsersController(IUserRepo user)
        {
            _user = user;
        }

        // GET: api/Users
        [HttpGet]
        public IEnumerable<User> GetUsers()
        {
            return _user.GetAllUsers();
        }

        // GET: api/Users/5
        [HttpGet("{id}")]
        public ActionResult<User> GetUser(int id)
        {
            var user = _user.GetUserById(id);

            if (user == null)
            {
                return NotFound();
            }
            return user;
        }

        // PUT: api/Users/5
        [HttpPut("{id}")]
        public IActionResult PutUser(int id, User user)
        {
            if (id != user.ID)
            {
                return BadRequest();
            }
            _user.UpdateUser(user);

            return CreatedAtAction("GetUser", new { id = user.ID }, user);
        }

        // DELETE: api/Users/5
        [HttpDelete("{id}")]
        public ActionResult<User> DeleteUser(int id)
        {
            var user = _user.GetUserById(id);
            if (user == null)
            {
                return NotFound();
            }

            _user.DeleteUser(id);

            return user;
        }

        [Route("name/{name}")]
        [HttpGet]
        public IEnumerable<User> GetUsersByName(string name)
        {
            return _user.GetUsersByName(name);
        }
    }
}
Solution

Click Run to check out the result. After the application has fully launched, click on the link to launch in a new browser tab. Remove /name/neo from the URL to obtain the complete list of users in the database in JSON format. From the output, pick any other name you would like and add /name/{the name you picked} into the URL.

Explanation

IUserRepo.cs

Start off by adding a new function definition to your repository ...