public ActionResult RecentOrders() { // var CurrentUserId = User.Identity.GetUserId(); // int StudentId = db.AspNetStudents.Where(x => x.StudentID == CurrentUserId).FirstOrDefault().Id; //var result = from Notes in db.AspNetNotes // join OrderNotes in db.AspNetNotesOrders on Notes.Id equals OrderNotes.NotesID // select new // { // Id = OrderNotes.Id, // Title = Notes.Title, // Discription = Notes.Description, // CourseType = Notes.CourseType, // Price = Notes.Price, // Quantity = OrderNotes.Quantity, // Status = OrderNotes.Status, // }; var result = db.StudentOrderDetails().ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }