Issue while converting linq result to JSON in MVC4 using JavaScriptSerializer

Question

Im trying to convert linq result to JSON using JavaScriptSerializer but i didn get the desired output.

My Code is(im using C#):

string Departments = "";
JavaScriptSerializer jss = new JavaScriptSerializer();
Departments =  jss.Serialize(db.Departments.ToList());
ViewBag.Department = Departments;

what i get is:

[{"DepartmentId":2,"DepartmentName":"Cardiology","EntityState":2,"EntityKey":{"EntitySetName":"Departments","EntityContainerName":"ClinicDbEntities","EntityKeyValues":[{"Key":"DepartmentId","Value":2}],"IsTemporary":false}},{"DepartmentId":6,"DepartmentName":"ENT","EntityState":2,"EntityKey":{"EntitySetName":"Departments","EntityContainerName":"ClinicDbEntities","EntityKeyValues":[{"Key":"DepartmentId","Value":6}],"IsTemporary":false}},{"DepartmentId":7,"DepartmentName":"Paediatrics","EntityState":2,"EntityKey":{"EntitySetName":"Departments","EntityContainerName":"ClinicDbEntities","EntityKeyValues":[{"Key":"DepartmentId","Value":7}],"IsTemporary":false}},{"DepartmentId":8,"DepartmentName":"General","EntityState":2,"EntityKey":{"EntitySetName":"Departments","EntityContainerName":"ClinicDbEntities","EntityKeyValues":[{"Key":"DepartmentId","Value":8}],"IsTemporary":false}}]

what i needed is like this:

[ { DepartmentId: 2, DepartmentName: "Cardiology" }, { DepartmentId: 6, DepartmentName: "ENT" },{ DepartmentId: 7, DepartmentName: "Paediatrics" },{ DepartmentId: 8, DepartmentName: "General"}]

can somebody help me please. Thank you in advance!

I4V · Accepted Answer · 2013-09-11 09:39:26Z

1

Departments= jss.Serialize(
              db.Departments.Select(d => new{
                    DepartmentId = d.DepartmentId,
                    DepartmentName = d.DepartmentName
                })
            );

answered Sep 11, 2013 at 9:39

I4V

35.4k6 gold badges71 silver badges82 bronze badges

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

Collectives™ on Stack Overflow

Issue while converting linq result to JSON in MVC4 using JavaScriptSerializer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related