Databases
StackOverflow2013
Postsdbo
POLinq - Referencing a Child Table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLinq - Referencing a Child Table
    primarykey
    data
    text
    <p>I have a few tables I'm dealing with regarding a "Goals" application (screen grab is below). I'm using MVC 3, razor and linq.</p> <p>I am using a model, goalsModel, to retrieve my data:</p> <p><code>public goals GetGoal(int id) { return qDB.goals.Single(g =&gt; g.goalID == id); } </code></p> <p>I'd like Activities to be available as well... where I could do something like:</p> <p><code>public goals GetGoalActivities(int id) { return qDB.ilpActivities.Where(g =&gt; g.goalID == id); }</code></p> <p>However this returns an error. The smart tags for don't show any columns available for ilpActivities. I've seen several methods of writing code in the controller where it's a linq query - but I'd really like to use the format above if possible for consistency.</p> <p>Here's a link that I've been trying to follow that may do what I want. Keep in mind, however, I'll eventually be editing existing activities, creating new ones, and deleting activities. The link: <a href="http://geekswithblogs.net/michelotti/archive/2007/12/30/118076.aspx" rel="nofollow">http://geekswithblogs.net/michelotti/archive/2007/12/30/118076.aspx</a></p> <p>[Edit] I couldn't post an image as a new user. My tables consist of goalID as the primary key of goals and foreign key in ilpActivities. ilpActivities has a primary key of activityID.</p> <p>[Update]</p> <p>My tables look something like this (simplified to include relevant fields): goals: goalID, goalName, goalDescr ilpActivities: activityID, goalID, activityName</p> <p>I have a dbml file: employeeDataClasses.dbml that was generated for me after dragging the tables in on design mode. It recognized ilpActivities as a child of goals</p> <p>I have a goalsModel.cs file:</p> <pre><code>namespace ILP.Models { public class goalsModel { #region services public interface IGoalsService { List&lt;goals&gt; GetAllGoals(string oprID); bool CreateGoal(goals poll); List&lt;ilpGoalStatus&gt; GetStatuses(); goals GetGoal(int id); bool EditGoal(goals poll); List&lt;ilpActivity&gt; GetGoalActivities(goals goal); } public class AssetService : IGoalsService { private goalsDataClassesDataContext qDB; public AssetService() { qDB = new goalsDataClassesDataContext(); } #region IGoalsService Members public List&lt;ilpActivity&gt; GetGoalActivities (goals goal) { IEnumerable&lt;ilpActivity&gt; activities = from g in qDB.goals join a in qDB.ilpActivities on g.goalID equals a.goalID where a.goalID == goal.goalID select a; return activities.ToList(); } </code></pre> <p>In my controller:</p> <pre><code>namespace ILP.Controllers { public class HomeController : Controller { private goalsModel.IGoalsService qService; public HomeController() { qService = new goalsModel.AssetService(); } [Authorize] public ActionResult _CreateActivity(int goalID) { //var status = qService.GetStatuses(); ViewBag.Status = new SelectList(qService.GetStatuses().ToList(), "goalStatusID", "goalStatus"); // not sure what to do here to get activity model in.... return PartialView(); } </code></pre> <p>In my create activity partialview I'm only getting access to the goals model:</p> <pre><code>@model ILP.Models.goals &lt;script src="@Url.Content("~/Scripts/jquery-1.5.1.min.js")" type="text/javascript"&gt;&lt;/script&gt; &lt;script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"&gt;&lt;/script&gt; &lt;script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"&gt;&lt;/script&gt; @using (Html.BeginForm()) { @Html.ValidationSummary(true) &lt;fieldset&gt; &lt;legend&gt;Create an Activity&lt;/legend&gt; &lt;div class="editor-label"&gt; @Html.LabelFor(model =&gt; model.goalName) &lt;/div&gt; &lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.goalName) @Html.ValidationMessageFor(model =&gt; model.goalName) &lt;/div&gt; .... etc.... </code></pre> <p>In my view I need to access activityName of ilpActivities - but the only options are coming from goals table. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEddie Wesley
    1. USEddie Wesley
    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
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat is the error.. is it exploding because the DataContext is dead by the time it tries to enumerate?
      singulars
      1. POLinq - Referencing a Child Table
      1. USQuintin Robinson
    2. CONo - It doesn't "see" the contents of my child table (ilpActivities). So when I try to add form fields: @Html.Editorfor(a => a.ilpActivities.activityName) -- the "activityName" doesn't appear in the smart tags
      singulars
      1. POLinq - Referencing a Child Table
      1. USEddie Wesley
    3. COIt appears that your ultimate question relates to your view. To pass your child table and its attributes to your view, you need to pass the view a model which contains your child table in its structure. Please post some detail about the structure of your tables, as well as about the structure of the model you want to pass to the view, as well as some more detailed code regarding your view. It is much easier to advise how to populate your model if we can see details about what you want to accomplish, and what you are working from.
      singulars
      1. POLinq - Referencing a Child Table
      1. UScounsellorben
 

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