Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
6
Reply
Display multiple Table records in 1 View in MVC
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Gurjeet Singh
10y
6.6k
1
Reply
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
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
which is better master page or _layout.cshtml view in MVC
I am using VS2012 with entity framework