How to retrieve this list of requests with the status of each request?
<p>I am a new ASP.NET Webforms developer. I am learning now how to use the Entity Framework and Repository Pattern. What I am struggling with right now is how to retrieve the list of requests from a TRequest table with the status of the approval of each request. Here's my database schema:</p>

<pre><code>TRequest: Id, Title, Reason
TApproval: Id, RequestId, StatusId
TStatus: Id, Title
</code></pre>

<p>What I want to do is to retrieve the list of requests including the status of each request.</p>

<p>In my repository pattern, I have the following code:</p>

<pre><code>public IEnumerable&lt;TRequest&gt; GetRequest()
{
    return context.TRequest.ToList();
}

public IEnumerable&lt;TRequest&gt; GetRequestByStatus(int statusId)
{
    return GetRequests().Where(r =&gt; r.TApproval.TStatus.Id).ToList();   //I got an error here
}
</code></pre>

<p><strong>Why Am I getting error in the second method GetRequestByStatus?</strong> I am unable to say <code>r.TApproval.TStatus.Id</code> and I don't know why. </p>