Select List returns System.Data.Entity.DynamixProxies instead of values in MVC asp.net C#

Question

I have got two different tables. User and ProjectDetails. There are two different controllers as well to do CRUD operations on these tables. Now, I have a case where, in the User CREATE operation, I have to select the Project from the List of Projects in ProjectDetails. I tried the following:

In the user model, I created this line:

    public IEnumerable<ProjectDetail> ProjectDetail { get; set; }

And in the controller, in the create Action, I have added the following code:

    public ActionResult Create()
    {
        var model = new UserDetail
        {
            ProjectDetail = db1.ProjectDetails
        };
        return View(model);
    }

And in the create view, I am trying to get the list of Project IDs as follows:

@Html.DropDownListFor( x => x.ProjectDetail, new SelectList(Model.ProjectDetail, "Project ID"))

However, wen i run, i get the number of lines (as equal to the number of projects) as

System.Data.Entity.DynamicProxies.ProjectDetails_F########### (Some numbers)..

Please can someone help me?

Regards, Hari

[EDIT] - I checked in the debug mode and found the following.. Tried attaching the image..

I drilled down that Proxy things and found ProjectID there. How can I get that?

you can map it to a dto first and then send it to the view ..something like stackoverflow.com/questions/4579598/… — Amitd
– Amitd, Commented May 1, 2013 at 10:39

von v. · Accepted Answer · 2013-05-01 10:41:10Z

4

You are using a wrong overload, use this instead:

@Html.DropDownListFor( x => x.ProjectDetail, 
    new SelectList(Model.ProjectDetail, "ProjectId","ProjectName"))
// where ProjectId is the unique identifier field of `ProjectDetail` 
// and `ProjectName` is the text you want to show in the dropdown

In your code you are not telling the html helper what properties to use for the datavalue and the datatext. The overload you use is the one where you tell the htmlhelper which value is selected.

answered May 1, 2013 at 10:41

von v.

17.1k5 gold badges62 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Hariprasauth Ramamoorthy Over a year ago

ROCKING!!!!!!!!!! Please now, could you tell me how to map this to the User field? I got the dropdown. I should map the value selected in the dropdown to the input field in User mode which is Project.

von v. Over a year ago

Do you have something like User.Project where Project has a field of Id? If yest then do x=>x.Project.Id, new Selectlist...

Hariprasauth Ramamoorthy Over a year ago

von v - Sorry one more doubt. This was easy in my create action. How could I possibly do this for Edit? public ActionResult Create() { var model = new UserDetail { ProjectDetail = db1.ProjectDetails }; return View(model); } Now, in the Edit - I have public ActionResult Edit(string id) { UserDetail userdetail = db.UserDetails.Find(id); return View(userdetail); }

von v. Over a year ago

You do the same thing you did for the add. After you query your object (Find(id)) do the userinstance.ProjectDetail = db1.ProjectDetails. Also, you might want to consider working with viewmodels, it's better than passing your entities/models around.

Hariprasauth Ramamoorthy Over a year ago

great. Sure.. Will check ViewModel approach.

|

Sam Leach · Accepted Answer · 2013-05-01 10:41:06Z

3

You can do something like

var projection = db1.ProjectDetails.Select(t => new ProjectDetailsViewModel
            {
                Prop1 = t.Prop1,
                Prop2 = t.Prop2
            });

answered May 1, 2013 at 10:41

Sam Leach

13k10 gold badges49 silver badges73 bronze badges

Comments

Pavan Kumar · Accepted Answer · 2013-05-01 10:29:59Z

0

Can you try

public ActionResult Create()
    {
        var model = new UserDetail
        {
            ProjectDetail = db1.ProjectDetails.ToList()
        };
        return View(model);
    }

answered May 1, 2013 at 10:29

Pavan Kumar

1902 silver badges8 bronze badges

3 Comments

Pavan Kumar Over a year ago

Try like [email protected]( x => x.ProjectDetail, new SelectList(Model.ProjectDetail, "Project ID"))

Pavan Kumar Over a year ago

sorry like this @Html.DropDownListFor( x => x.UserDetail.ProjectDetail, new SelectList(Model.UserDetail.ProjectDetail, "Project ID"))

Hariprasauth Ramamoorthy Over a year ago

Looks lik, I have to have a different overload. Please check von v answer. Its working.. :)

Collectives™ on Stack Overflow

Select List returns System.Data.Entity.DynamixProxies instead of values in MVC asp.net C#

3 Answers 3

7 Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related