asp.net mvc 3 return json array

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)?

2 Answers

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.

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); }