Display multiple Table records in 1 View in MVC

Question

Hi,

I have 3 Tables

 

1 Table: Sale Table with Following columns

id, req_no, Bill_amt

 

2 Table : dtls Table with following columns

id,Req_no,brand,product

 

3 Table: bill Table with the following columns

id,req_no,Paid_amt

 

i have query in Sql but now i am using Linq so how can write same query in Linq

 

select m.req_no,m.Bill_Amt,d.Brand,d.Product,b.Paid_Amt from sale_mstr m, sale_dtls d, bill_dtls b where m.req_no=d.req_no
and m.req_no=b.req_no and d.Brand='Apple'

 

and display all records in View