ASP.NET MVC Foreign Key using Entity Framework

Question

I have a parent table and a child table.

Parent Table: int AID, nvarchar parentname, nvarchar description

Child Table: int CID, int AID, nvarchar childname, nvarchar address

Child table has got a foreign key(AID) from parent table. I need to display the list of Child table in view page. I'm new to asp.net mvc and the problem is, I'm not able to get the parentname to be displayed along with the childtable.

As we have foreign key, it should be possible to get the parentname using AID. Can anybody sort it out using some simple example. I'm struggling with this for the last 7hours.

Consider the Parent table to be an account and child to be a list of contacts associated with the account.

Parent Table => PID,PName, PAddress Child Table => CID,PID,CName,CAddress

Output Table => PName,CName,CAddress

Controller:

public ActionResult list()
{
var listing = db.child.FindContact().ToList();
return view(listing);
}

View snippet(.aspx):

<%: foreach(var a in Model) %>
{
<%: a.PName %>
<%: a.CName %>
<%: a.CAddress %>
}

Thanks.

ema · Accepted Answer · 2011-08-03 11:33:00Z

1

Your Child object should have a property of type Parent. Check this. Then you can write a.Parent.PName on the view.

answered Aug 3, 2011 at 11:33

ema

5,7931 gold badge28 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user876289 Over a year ago

But i get an error that, "Object reference not set".As it is creating the list dynamically, it should display the PName according the PID-foreign key.

ema Over a year ago

Yep. I forgot one thing. During the load you should specify that you also need the parent. Should be something like: db.Child.Include("Parent").ToList()

user876289 Over a year ago

Thank you very much. It works now. But db.Child.Include("Parent").ToList() can be used only for the .edmx model and it cannot be used for .dbml model I guess. Thanks anyway.

Collectives™ on Stack Overflow

ASP.NET MVC Foreign Key using Entity Framework

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related