public IEnumerable <ALeague.Models.Ladder> RMLadder_GetData() { var db = new Models.LadderEntities(); // LINQ var results = (from si in db.Ladders orderby si.clubID ascending, si.position ascending, si.clubName ascending, si.matchesPlayed ascending, si.win ascending, si.draw ascending, si.lost ascending, si.goalsFor ascending, si.goalsAgainst ascending, si.goalDifference ascending, si.points ascending, si.thumbnail select si).ToList(); // Lambda // results = db.Ladders // .OrderBy(si => si.clubID) // .ThenBy(si => si.position) // .ThenBy(si => si.clubName) // .ThenBy(si => si.matchesPlayed) // .ThenBy(si => si.win) // .ThenBy(si => si.draw) // .ThenBy(si => si.lost) // .ThenBy(si => si.goalsFor) // .ThenBy(si => si.goalsAgainst) // .ThenBy(si => si.goalDifference) // .ThenBy(si => si.points) // .Select(si => si) // .ToList(); return(results); }
// The id parameter should match the DataKeyNames value set on the control // or be decorated with a value provider attribute, e.g. [QueryString]int id public ResultDetail FVResult_GetItem([QueryString] int id) { var db = new Models.LadderEntities(); var result = (from r in db.Ladders where r.clubID == id select new ResultDetail { clubID = r.clubID, result = r }).FirstOrDefault(); return(result); }