Databases
StackOverflow2013
Postsdbo
PODisplaying content under an ID
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplaying content under an ID
    primarykey
    data
    text
    <p>I have been studying EF and LINQ for quite a while now and I'm stumped on my inability to gather answer on the process that I'm trying to accomplish below:</p> <p>In the index view, I would like to have a tabular list of all CD with their respective Contents. Please see below classes for more info:</p> <pre><code> public class Cd { public int cdID { get; set; } public string cdName { get; set; } public string tag { get; set; } public Content Content { get; set; } } public class Content { public int contentID { get; set; } public string contentName { get; set; } public string category { get; set; } } </code></pre> <p>Given the classes, how can I achieve what I'm trying to do - display all CD contents under a CD using an cdID?</p> <p>Update #1 - Final Answer ( thanks to DryadWoods)</p> <pre><code>public class Cd { public int cdID { get; set; } public string cdName { get; set; } public string tag { get; set; } public IList&lt;Content&gt; Content { get; set; } //Changes here! No changes in Content class } </code></pre> <p>Final Version of the view:</p> <pre><code>@model IEnumerable&lt;MediaManager.Models.Cd&gt; &lt;table&gt; &lt;tr&gt; &lt;th&gt;CD ID&lt;/th&gt; &lt;th&gt;Content&lt;/th&gt; &lt;/tr&gt; @foreach (var cd in Model) //nested loop for displaying the cdID, then proceeds to loop on all contents under certain cdID { &lt;tr&gt; &lt;td&gt; @Html.DisplayFor(modelItem =&gt; cd.cdID) &lt;/td&gt; &lt;td&gt; @foreach (var item in cd.Content) { &lt;p&gt;@item.contentName&lt;/p&gt; } &lt;/td&gt; &lt;/tr&gt; } &lt;/table&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKevinIsNowOnline
    1. USKevinIsNowOnline
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODisplaying content under an ID
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou're saying a `Cd` has many `Content` objects, right? So shouldn't `Content` be an array?
      singulars
      1. PODisplaying content under an ID
      1. USMcGarnagle
    2. COI agree, I ended up changing the datatype of Content to public IList<Content> Content { get; set; }..
      singulars
      1. PODisplaying content under an ID
      1. USKevinIsNowOnline
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload