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?
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();
}
DistinctBy?? , LinQ only hasEnumerable.Distinct Method. And what is this Select overload learn.microsoft.com/en-us/dotnet/api/…? Does this compile?IEnumerable<user>. I expect element fromentities.usersto be type ofuser. So what are you trying to return as object new user with only some poperties initialise so perhapsSelect(x=> new user{prop1= x.Prop1})? or are you trying to select like this : Select Multiple Fields from List in Linq