Web Api 2 With Entity Framework Controller return all navigation properties

Question

I am trying to get informations from my User table with User's ID but my controller returns all of navigation properties that connected with foreign keys to other tables.

Code is simply webapi method:

[ResponseType(typeof(User))]
    public IHttpActionResult GetUser(int id)
    {
        User user = db.User.Find(id);
        if (user == null)
        {
            return NotFound();
        }

        return Ok(user);
    }

It doesn't return only User, it returns all navigation properties connected with this User.

How can I return only User?

This post explains selected properties. I want all of properties, but controller returns me all of connected tables datas with foreign keys too.

Hmm, Find shouldn't load the navigation properties. Are you saying the FKs are populated or the navigation properties? stackoverflow.com/questions/5764391/… — Steve Greene
– Steve Greene, Commented Jan 12, 2016 at 18:34
Possible duplicate of Entity Framework - Load only Selected properties — Fabio
– Fabio, Commented Jan 12, 2016 at 18:40
Yes, I would go with Fabio's suggestion and use a projection. Exposing your entity model in an api is dangerous. — Steve Greene
– Steve Greene, Commented Jan 12, 2016 at 18:51
So what is the best practice if there are so much column at table? — Tugrul Emre Atalay
– Tugrul Emre Atalay, Commented Jan 12, 2016 at 18:58

Wahid Bitar · Accepted Answer · 2016-01-12 21:58:15Z

2

The best practice for Web-Applications is to disable the LazyLoadin in your DbContext.

context.Configuration.LazyLoadingEnabled = false;

answered Jan 12, 2016 at 21:58

Wahid Bitar

14.1k13 gold badges83 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tugrul Emre Atalay Over a year ago

so you are dissident with @FabioLuz, he says it works but its not solution for this.

Wahid Bitar Over a year ago

Actually, it's always better to return specific view model containing just the needed data. But it always up to your project if it's huge and you want to add this kind of complexity or it's simple and you want just to go with your Entities.

Wahid Bitar Over a year ago

@TuğrulEmreAtalay abi please accept my answer if you found it useful ;)

Collectives™ on Stack Overflow

Web Api 2 With Entity Framework Controller return all navigation properties

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related