CODEWITHSUNDEEP
asp.net-mvcasp.net-mvc-2foreign-keys
user876289
user876289

Reputation:

Foreign Key relationships in ASP.NET MVC

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.

Upvotes: 1

Views: 1297

Answers (1)

WingMan20-10
WingMan20-10

Reputation: 3734

First you need to create an object(ViewModel) that has all the properties from parent and a collection of children.

This is exactly how you need to do it..

http://stephenwalther.com/blog/archive/2009/04/13/asp.net-mvc-tip-50-ndash-create-view-models.aspx

Upvotes: 1

Related Questions