0

I have generated the edmx model from the existing database and also using the EF4 DbContext to generate the model classes. Then I have created the partial classes with the same name to use for annotations. So far so good. But now I come to a point to edit a user. The user has UserType parameter which is a one to many relationship in the database. Basically I would like to achieve here is that I will put a html.dropdownlistfor for the model and it will pick up the all the usertype from the user type table and populate the dropdown list. What is the way of achieving this?

This is the field which is generated automatically by EF. 

        public virtual UserType userType { get; set; }

What changes I should make in the controller to get the list of the usertypes to pass it to the view?

akd
  • 6,538
  • 16
  • 70
  • 112
  • Duplicate of [Create a Dropdown List for MVC3 using Entity Framework (.edmx Model) & Razor Views && Insert A Database Record to Multiple Tables](http://stackoverflow.com/questions/5326515/create-a-dropdown-list-for-mvc3-using-entity-framework-edmx-model-razor-vie). – CodeCaster Nov 08 '13 at 14:43
  • As explained in duplicate, don't use database models as viewmodels. Create a viewmodel that contains a `UserType` and an `UserTypes` property, where you populate the latter with all selectable models. – CodeCaster Nov 08 '13 at 14:44
  • so when you request data for parent table use include extension method which 'll load usertype which is child table . syntax look like .... DBEntities.ParentTB.Include(x => x.userType).toList(); – Vishal Sharma Nov 09 '13 at 05:10

0 Answers0