public ActionResult Create([Bind(Include = "FirstName,LastName,Title")] Person person) { if (ModelState.IsValid) { using (var pp = new AdventureWorksDataContext()) { person.ModifiedDate = DateTime.Now; person.PersonType = "EM"; person.BusinessEntityID = 1; var businessEntity = new BusinessEntity(); businessEntity.ModifiedDate = DateTime.Now; businessEntity.Person = person; businessEntity.rowguid = Guid.NewGuid( ); person.BusinessEntity = businessEntity; pp.BusinessEntities.InsertOnSubmit(businessEntity); pp.Persons.InsertOnSubmit(person); pp.SubmitChanges(); } return RedirectToAction("Index"); } return View(person); }
public ActionResult Index() { ViewBag.Title = "Person Index"; List<Person> list; using (var pp = new AdventureWorksDataContext()) { list = (from item in pp.Persons select item).ToList(); } ViewBag.Persons = list.Take(100); return View(); }
public ActionResult SortIndex1() { ViewBag.Title = "Sorted Person Index"; List<Person> list; using (var pp = new AdventureWorksDataContext()) { var dat = (from item in pp.Persons select item).ToArray(); list = (from item in dat orderby item.LastName, item.FirstName select item).ToList(); } ViewBag.Persons = list.Take(100); return View(); }