Hi i have two tables
Country (id,name)
City(id,Country_Id,CityName)
Now when I am adding Record to country table , it is now showing on index view unless until I add a city with that country as well below is my controller linq query.
var test1 = (from c in db.Countries join cc in db.Cities on c.Id equals cc.Country_Id
select new { Id = c.Id, CountryName = c.CountryName, Code = c.Code, IsActive = c.IsActive,
// IsActive = g.IsActive, Date_Created = c.Date_Created, Date_Modified = c.Date_Modified,
}).ToList(); return Json(new { data = test1 }, JsonRequestBehavior.AllowGet); }