How to view recoed in MVC 4 using foreing key

Sudhir Sharma

13y1.7k.NET

Hi,

Kindly tell me some one how can i view record from 3 tables, third maintain fk from first two tables. i am using Entity framework with linq.

Regards
Sudhir

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sudhir Sharma13y ago

First one table is Employee Master ,second one for Project Master and last one is for Employee Project , which reference from Project master and also from Employee Master.
My question is " How can i populate data from Employee Project Master in MVC 4 Razor"
Jignesh Trivedi13y ago
hi,
as per your table structure, there is many - many relation between Employee and Product.
so you may find many employee with in one product and vise versa
please share what you want show on the screen?
please share you screen design so that I can help you.
Sudhir Sharma13y ago
Hi Dear,

Thanks for quick response.

I have 3 tables like :

1: Employee (Empid PK, EmployeeName varchar(44))

2: Product (ProdId pk int, ProductName varchar(44))

3 : Employee_Product (EP_id int, Employee FK (from Employee) ,Product FK (form Product) )

Plz tell me how can i view data in View from controller.

if is it possible to share ur cell no. Plz share with me .

Thanks
Sudhir
Cell : 9555289718
Jignesh Trivedi13y ago
hi,
if you have 3 table says, Empmaster , People and Address and relation is asblow
EMpMaster EmpID is foreing key with people table
People PeopleID is foreing key with address table
EmpMaster --> People --> Address.
now from entity side you must include path upto address relation.
example
ModelContext cx =new ModelContext();
var emp = cx.EmpMaster.Include("People.Address").Where(r=>r.EmpId == 1000);
now it return from controller to View
In view you can use following syntax to view Data of Addresses like.
<%: Html.TextBoxFor(m => m.People.Address.Line1) %>
here i am assuming that there is one to one relation between EmpMaster --> People --> Address.
hope this will help you.