trying to use include in lambda getting an error

Question

I am trying to query the comments that has relationship with request table like this below

public class Request
{
    public Guid Id { get; set; }
    [Column(TypeName = "jsonb")]
    public Correspondence Correspondence { get; set; }
    public MasterSection MasterSection { get; set; }
    public RequestStatus RequestStatus { get; set; }
    public RequestStage RequestStage { get; set; }
    public RequestType RequestType { get; set; }
}

and here is my class for correspondence class below

 public class Comment
{
    public string Text { get; set; }
    public string CommentBy { get; set; }
    public DateTime CreatedAt { get; set; }
}
public class Correspondence
{
    public List<Comment> Comments { get; set; } = new List<Comment>();
}

and here is my linq query to get the results

 public IQueryable<Request> GetAllRequests()
 {
        return _dbContext.Requests.Include(i =>i.RequestStage)                                 
                                  .Include(i =>i.RequestType)
                                  .Include(i =>i.MasterSection)
                                  .Include(i=> i.Correspondence).ThenInclude(i=> i.Comments);

  }

but getting an error like Lambda expression used inside Include is not valid. with out including correspondence, the above query is working is fine but when i included the correspondence getting above error.

Is there any other way to get all those related data along with correspondence for the requests

I am using EF core 3.0

Could any one have any idea why i am getting this error and any idea how to overcome this error that would be very grateful to me.

Thanks in advance

sample data

Instead of .ThenInclude have you tried chaining .Include("Correspondence.Comments")? — Matt U
– Matt U, Commented Dec 18, 2019 at 19:15
i tries getting the same error that i was mentioned in the question return _dbContext.Requests.Include(i => i.RequestStage) .Include(i => i.RequestType) .Include(i => i.MasterSection) .Include(i => i.Correspondence) .Include("Correspondence.Comment") — Glory Raj
– Glory Raj, Commented Dec 18, 2019 at 19:18
i already shared above in the question about request object with the correspondence class and i am using code first approach, please let me know if you need more info — Glory Raj
– Glory Raj, Commented Dec 18, 2019 at 19:24

vendettamit · Accepted Answer · 2019-12-18 21:03:25Z

1

As mentioned in comments of Question, correspondence is a blob field in the request table itself you don't need to use Include. Include is for loading related entities.

answered Dec 18, 2019 at 21:03

vendettamit

14.7k2 gold badges36 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

trying to use include in lambda getting an error

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