Databases
StackOverflow2013
Postsdbo
PONewbie - combining parent and child views into one page
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONewbie - combining parent and child views into one page
    primarykey
    data
    text
    <p>I am trying to learn mvc - I apologize in advance for all the silly questions. What I've done is created an mvc proejct based on an exsiting database, and then i've been disecting it to try to understand what's been created for me, and how to create my own stuff. Unfortunately, because I'm a new stackoverflow user, i can't post a picture of my project structure.<br> i have a parent controller and a child controller created using the wizard based on 2 separate tables i have in my model. I want to display both of them in one view - ultimately in a webgrid and be able to change data for any parent item, or child item. You can ignore the CombinedController for now. I've been doing some reading and i've learned that i should be creating a viewmodel that combines both the parent and child at the model level, and then go from there.</p> <p>so i created this class: </p> <pre><code>Imports System.Data.Objects.DataClasses Public Class ParentAndChild Public Property myChildren As IEnumerable(Of Child) Public Property myParent as Parent End Class </code></pre> <p>I have a few questions:</p> <p>Question 1<br> Do i have to add this ParentAndChild entity into the .edmx file in order to create a controller and view for it? I guess what I'm really asking is do i have to create a view in the sql database first, have the entity show up in the .edmx and then create a controller? Or can I just combine the two entities in a class? That's what i've done so far. I don't have a sql View in my database combining these two tables. The reason why I ask is because when i create my controller, if i want to get all the CRUD for free, i have to create using the Entity Framework. But I don't know what to specify for the data context.</p> <p>Question 2<br> If i want a webgrid to somehow show all my parents and all their children, will the new ParentAndChild class work? I think that will only show the details for One parent and its children. I think i need to create a list of parents.. and then in the parentlist for each parent, add a collection of modules. But i don't know how to do this..</p> <p>Question 3<br> How does the entityframework know which modules to return when i'm using my new class? I don't define the relationship anywhere... Is it because in the .edmx file, the system knows the relationships between the tables? </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStereško
    1. USdot
    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. VO
      singulars
      1. PONewbie - combining parent and child views into one page
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PONewbie - combining parent and child views into one page
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PONewbie - combining parent and child views into one page
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI think the answer Question 2 is to create the following: Public Class SingleParentAndChildren public property myParent as Parent public property myChildren as IEnumerable(Of Child) end Class Public Class ListofParentsAndChildren public property AllParents as List(Of SingleParentAndChildren) End Class
      singulars
      1. PONewbie - combining parent and child views into one page
      1. USdot
 

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