How to get specific field(s) from database?

public class UserController : ApiController
    {
        UserSampleEntities entities = new UserSampleEntities();
      
        // GET api/<controller>
        [Route("api/User")]
        public IEnumerable<user> Get()
        {

            {
                return entities.users;

            }
        }
   }

This returns the json with all the entries in the database with all its properties. How do I filter such that I can obtain a json for only specific properties?

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Create a new class that represents a user using only the properties you want to expose from "api/User":

public class UserDto
{
    public int Foo { get; set; }

    public string Bar { get; set; }

    // add the properties you need here
}

Rewrite your API action to this:

[Route("api/User")]
public IEnumerable<UserDto> Get()
{
    return entities.users
        .Select(u => new UserDto
        {
            Foo = u.Foo,
            Bar = u.Bar,
            // map the properties you need here
        })
        .ToArray();
}

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0