mysql - Nested foreach from 2 different tables -

mysql - Nested foreach from 2 different tables -

titletable texttable ------------------- --------------- id(int) id (int) title(string) titletableid (int) text (string) titleoftext(int)

so here seek do: have 1 table holds title (titletable) , 1 more table holds text(text table), 1 title have several text that's why utilize 2 tables. , can list table 1 here code view:

@foreach (var item in model.titletable) { @item.title }

and not need foreach bring text of titles tried ;

@foreach (var item in model.titletable) { @item.title foreach (var itemdesc in model.text.orderby(o => o.id).where(o => o.id == item.id)) { @itemdesc.text } }

and returns null because dont give id homecoming takes view model not controller how can reach text , should @ end ;

title 1 text 1of title 1 text 2of title 1 title 2 text 1 of title2 text 2 of title2 @foreach (var item in model.titletable) { @item.title foreach (var itemdesc in model.text.where(o => o.titletable== item.id)) { @itemdesc.text } }

this doesn't create sense me:

.where(o => o.id == item.id)

you're matching titletable.id value texttable.id value? perhaps meant instead:

.where(o => o.titletableid == item.id)

assuming texttable.texttableid foreign key titletable.id value you'd compare filter collection.

mysql asp.net-mvc-4