// GET: AirVinyl public ActionResult Index() { var context = new AirVinylContainer(new Uri("http://localhost:15707/odata")); var peopleResponse = context.People .IncludeTotalCount() .Expand(p => p.VinylRecords) .Execute() as QueryOperationResponse <Person>; var peopleAsList = peopleResponse.ToList(); DataServiceQueryContinuation <Person> token = peopleResponse.GetContinuation(); peopleResponse = context.Execute(token); peopleAsList = peopleResponse.ToList(); string additionalData = "Total count:" + peopleResponse.TotalCount.ToString(); // select people by FirstName.EnsWith("n") //var peopleResponse = context.People // .Expand(p => p.VinylRecords) // .Where(p => p.FirstName.EndsWith("n")) // .OrderByDescending(p => p.FirstName) // .Skip(1) // .Take(1); //var peopleAsList = peopleResponse.ToList(); //// selest names //var selectFromPeople = context.People.Select(p => new { p.FirstName, p.LastName }); //string additionalData = ""; //foreach (var partialPerson in selectFromPeople) //{ // additionalData += partialPerson.FirstName + " " + partialPerson.LastName + "\n"; //} //// var personResponse = context.People.ByKey(1).GetValue(); //// add new Person() //var newPerson = new Person() //{ // FirstName = "Maggie", // LastName = "Smith" //}; //context.AddToPeople(newPerson); //context.SaveChanges(); //// Updated person //newPerson.FirstName = "Violet"; //context.UpdateObject(newPerson); //context.SaveChanges(); //// Delete person //context.DeleteObject(newPerson); //context.SaveChanges(); //var peopleResponse = context.People.OrderByDescending(p => p.PersonId); //var peopleAsList = peopleResponse.ToList(); return(View(new AirVinylViewModel() { People = peopleAsList, Person = personResponse, AdditionalData = additionalData })); }