I am new to LINQ and Entity framweork and I am stuck at one place.So, I have 2 table with one to many relationship. Let's say college and students.

```
public class Student
{
    [Key]
    public int StudentId { get; set; }
    public int ParentId {get;set;}  
    public ICollection<College> Colleges { get; set; }
}

public class College
{
    [Key]
    public int CollegeId { get; set; }
    public bool AdmissionStatus { get; set; }
     public string StudentId { get; set; }
    public virtual Student Student { get; set; }
}

```

**Requirement:**

Step 1: I will get `one parent ID (from UI)`, I need to find all the Student with that `parentID` from `Students` table.

Step 2: Now I will get list of Students or StudentsId for a particular parent, and now I want to query that list on students in the `college table` and `find all the students whose status AdmissionStatus is "True"`.

P.S: 

1. College can only set two status Accept = true or Reject = false.
2. Once a student status is accepted then No college can make the Status as "Accepted".
3. So, Many college can keep on rejecting a candidate, But once a college accepts the status. Then no college will be able to either reject or accept. Basically that student will not be visible for any college.

I am not sure how to achieve this.

```
  public ActionResult Show()
        {
            var parentId = User.Identity.GetUserId();
            var StudentList = _context.Students.Where(r => r.ParentId == parentId).ToList();
            // now I want to query the College table now, but I am not sure how to achieve it.
            return View();
        }

```

Each StudentId from the studentlist will be present many times in College table. 
I just want those ones which are accepted or AdmissionStatus = true. Please guide me.

Above mentioned situation is hypothetical, bear with me.