Beispiel #1
0
        private static void QueryDB()
        {
            ScoreDBContext db = new ScoreDBContext();

            //IQuery VS IEnumable
            //var query = from score in db.Scores
            //            group score by score.StuName into StuGroup
            //            select new
            //            {
            //                Name = StuGroup.Key,
            //                AvgScore = StuGroup.Aggregate(new ScoreStatic(), (acc, e) => acc.Accumlate(e), acc => acc.Computer())
            //            } into results
            //            orderby results.AvgScore
            //            select results;

            var query = db.Scores.GroupBy(s => s.StuName)
                        .ToList()
                        .Select(g =>
            {
                return(new
                {
                    Name = g.Key,
                    AvgScore = g.Aggregate(new ScoreStatic(), (acc, e) => acc.Accumlate(e), acc => acc.Computer())
                });
            })
                        .OrderByDescending(r => r.AvgScore);


            query.ToList().ForEach(e =>
            {
                Console.WriteLine(e.Name + "\t" + e.AvgScore);
            });
        }
Beispiel #2
0
        private static void CreateDB(List <Score> scores)
        {
            ScoreDBContext db = new ScoreDBContext();

            if (db.Scores.Any())
            {
                return;
            }
            db.Scores.AddRange(scores);
            db.SaveChanges();
        }