or
public ActionResult PopulateCalendar() { using (var entities = new OpenRoad.Data.Repository.OpenRoadEntities()) { var appointments = (from e in entities.Appointments where e.UserId == OpenRoad.Web.Session.UserId select new Models.Calendar { TaskID = e.AppointmentId, UserId = e.UserId ?? '1', Title = e.Subject, Description=e.Description, Start = e.StartTimeUtc ?? DateTime.Now, End = e.EndTimeUtc ?? DateTime.Now, IsAllDay = false, }).OrderBy(o => o.Start).ToList(); return Json(appointments, JsonRequestBehavior.AllowGet); } }public JsonResult LoadAllUsers([DataSourceRequest]DataSourceRequest request){ var repo = new AdminRepository(); var users = repo.LoadAllUsers(); var resp = users.Select(u => new { u.UserId, u.UserName, u.FirstName, u.LastName, u.EmailAddress, u.LastActivityDate, }); var data = resp.ToList().ToDataSourceResult(request); // var data = resp.Skip(20).Take(20).ToList(); return Json(data, JsonRequestBehavior.AllowGet);}$('#grid').kendoGrid({dataSource: {transport: {read: '/AdminJson/LoadAllUsers'},schema: {model: {fields: {UserId: { type: 'number' },UserName: { type: 'string' },FirstName: { type: 'string' },LastName: { type: 'string' },EmailAddress: { type: 'string' },LastActivityDate: { type: 'date' }}}},pageSize: 20,serverPaging: true,serverFiltering: false,serverSorting: true,scrollable: true},height: 430,pageable: true,filterable: false,sortable: true,columns: [{ field: 'UserId', title: 'User ID', sortable: false, filterable: false, groupable: false },{ field: 'UserName', title: 'User Name', sortable: true, filterable: false, groupable: false },{ field: 'FirstName', title: 'First Name', sortable: true, filterable: false, groupable: false },{ field: 'LastName', title: 'Last Name', sortable: true, filterable: false, groupable: false },{ field: 'EmailAddress', title: 'Email Address', sortable: true, filterable: false, groupable: false },{ field: 'LastActivityDate', title: 'Last Activity Date', sortable: true, filterable: false, groupable: false, format: '{0: yyyy-MM-dd HH:mm:ss}' }]});