Databases
StackOverflow2013
Postsdbo
POmvc 3 - Model with multiple IEnumerable
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmvc 3 - Model with multiple IEnumerable
    primarykey
    data
    text
    <p>I'm looking for the best approach to my problem. </p> <p>I need to display the names only of 3 different entities, not the rest of the information. </p> <p>Entities are:</p> <p><code>db.TR{TRID, ProjectID, TemplateID, version}</code><br> <code>db.Project{ProjectID, ProjectName}</code><br> <code>db.Template{TemplateID, TemplateName}</code> </p> <p>I would like the best approach to display all the results in a grid like this: </p> <p><code>TRID - ProjectName - TemplateName - Version</code> </p> <p>I would like to know how you would do the Model, Controller(Index Function) and the view. </p> <p>So far, my View function looks like this: </p> <pre><code>public ViewResult Index() { var viewModel = from tr in db.TRs join proj in db.Projects on tr.ProjectID equals proj.ProjectID join templ in db.Templates on tr.TemplateID equals templ.TemplateID orderby proj.ProjectName select new { TRList = tr.TRID, TemplateList = templ.TemplateName, ProjectList = proj.ProjectName, Version = tr.version } return View(viewModel); //Go in Index.cshtml } </code></pre> <p>And the View is: </p> <pre><code>@model IEnumerable &lt;OnlineTR.WebUI.Areas.Admin.Models.TRManagerModel&gt; @foreach (var item in Model) { &lt;tr&gt; &lt;td&gt; @Html.DisplayFor(modelitem =&gt; item.TRList); &lt;/td&gt; &lt;td&gt; @Html.DisplayFor(modelitem =&gt; item.ProjectList); &lt;/td&gt; &lt;td&gt; @Html.DisplayFor(modelitem =&gt; item.TemplateList); &lt;/td&gt; &lt;/tr&gt; } </code></pre> <p>I'm trying to find a way to use a sql request that only use what I need. </p> <p>If you can show me how to use the .include, it would be awesome. So far I have try, but it doesn't accept lambda expressions in the (), it wants a string path. (maybe missing a using?) </p> <p>Thanks a lot. Alex.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USalex
    1. USalex
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour question is not very clear. You haven't fully defined what your problem is. You say "it doesn't accept lambda expressions in the ()". What doesn't? What's the ()? If you have an error please include that.
      singulars
      1. POmvc 3 - Model with multiple IEnumerable
      1. USErik Funkenbusch
    2. COTo use Include() with lambda expression, you need `using System.Data.Entity;`. But it is not clear, how it relates to the problem you are solving. Please, clarify your question.
      singulars
      1. POmvc 3 - Model with multiple IEnumerable
      1. USJuraj Suchár
    3. COOh sorry. I did db.TR.Include(x => x.Project) and I got an error when compiling. It said that it was expecting a string path as an argument. Like db.TR.Include("Project") . This thing built, but return NULL.
      singulars
      1. POmvc 3 - Model with multiple IEnumerable
      1. USalex
 

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