Entity Framework Code First One to Many relationship return data using web api

Question

These are my model and I am using entity framework code first approach.

 public class Respondent
    {
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int RespondentId { get; set; }
        public User Requester { get; set; }

        public User Provider { get; set; }
        public string Role { get; set; }

        [NotMapped]
        public ICollection<User> Providers { get; set; }
    }

public class User
    {
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int UserId { get; set; }
        public int UPI { get; set; }
        public string Name { get; set; }


        public string Email { get; set; }


        public bool IsPublic { get; set; }
        [NotMapped]
        public string Profile_Pic { get; set; }
        [NotMapped]
        public string Role { get; set; }
        [NotMapped]
        public List<string> Roles { get; set; }
    }

Now I want to get all respondents by using following web api method but i am not getting correct result set and it is showing null values for Provider and requester and only returning respondent id.

        public IQueryable<Respondent> GetRespondents()
        {
            return db.Respondents;
        }

bolkay · Accepted Answer · 2019-05-04 23:37:50Z

1

You can use the Include() function to load related data through your model's navigation properties.

Something like this.

// GET: api/Respondents


public IQueryable<Respondent> GetRespondents() 
{ 
return db.Respondents.
Include(user=>user.Requester)
    .Include(pro=pro.Providers).ToList();
}

Note that if you are using EntityFramework Core, you need the following namespace

using Microsoft.EntityFrameworkCore;

Otherwise you need:

using System.Data.Entity;

edited May 4, 2019 at 23:37

answered May 4, 2019 at 23:29

bolkay

1,94912 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Code First One to Many relationship return data using web api

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related