public JsonResult GetCountries() { using (MyDatabaseEntities context = new MyDatabaseEntities()) { var ret = context.Countries.Select(x=>new { x.CountryId,x.CountryName}).ToList(); return Json(ret, JsonRequestBehavior.AllowGet); } }
public JsonResult GetStates(int countryId) { using (MyDatabaseEntities context = new MyDatabaseEntities()) { var ret = context.States.Where(x => x.CountryId == countryId).Select(x => new { x.StateId, x.StateName }).ToList(); return Json(ret); } }
public JsonResult GetAll() { using (MyDatabaseEntities context = new MyDatabaseEntities()) { var ret = context.Countries.Include("State").Select(x => new { x.CountryName, x.CountryId, States = x.States.Select( y=>new { y.StateId,y.StateName }) }).ToList(); return Json(ret, JsonRequestBehavior.AllowGet); } }