Querying parent from child table in EntityFramework

#csharp #dotnet #entityframework

I was looking at getting childrens of a parent table by querying the table only.
To give you a context of the data I had the following models:


// this is the parent class
class Projects {
public Guid Id;
public List<Comments> comments;
... //other fields
}

// this is the child 1-M
class Comments{
public Guid Id;
public Project project;
... //other fields
}

Once I've injected the dbcontext class, I start querying the database the following way with AsQueryable() if you don't put this you won't be able to call up the search by id.

...
var projectId = "<<guid>>"

List<Comment> entity = await _context.Comments.AsQueryable().Where(it => it.Project.Id == projectId ).ToListAsync();
...