asp.net mvc 3 return json array

Question

Trying to generate an array on the client side for js:

var ds = [{ text: "john", value: "1" }, { text: "paul", value: "2" }];

In my asp.net mvc 3 controller I have created a entityframework model and trying to return a list :

NORTHWNDEntities db = new NORTHWNDEntities();
public ActionResult GetCustomers()
{ 
    return Json( db.Customers,JsonRequestBehavior.AllowGet);
}

at the moment I cant figure out just to return the customername+customerid property as a list of customers (NWind database)?

Adam Tuliper · Accepted Answer · 2013-09-10 06:19:28Z

10

Try this - for each customer create a new anonymous object with the properties you want.

public ActionResult GetCustomers()
{ 
    var customers = from o in db.Customers
                select new { customerName = o.CustomerName, customerId = o.CustomerId};

    return Json(customers.ToList(), JsonRequestBehavior.AllowGet);
}

Note if you want for ex. "text" and "value" to be the values in your JSON array simply change customerName and customerId above to whatever names you want.

edited Sep 10, 2013 at 6:19

answered Sep 10, 2013 at 0:20

Adam Tuliper

30.2k4 gold badges56 silver badges71 bronze badges

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

1 Comment

jcmwangi Over a year ago

How could I include a where clause in that query?

Roger Barreto · Accepted Answer · 2013-09-10 01:32:26Z

5

try this:

public ActionResult GetCustomers()
{ 
     var customers = for c in db.Customers
            select new { text = c.CustomerName, value = c.CustomerId};

     return Json( customers.ToArray(), JsonRequestBehavior.AllowGet);
}

answered Sep 10, 2013 at 1:32

Roger Barreto

2,2841 gold badge19 silver badges24 bronze badges

Collectives™ on Stack Overflow

asp.net mvc 3 return json array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related