コード例 #1
0
        static void ViewTest()
        {
            var str = "";

            using (var db = new SqliteDbContext())
            {
                var list = db.VStats.Where(p => p.CLASS_NAME == str && p.POINTS == 9).ToList();
                foreach (var item in list)
                {
                    Console.WriteLine($"{item.STUDENT_NAME}\t{item.CLASS_NAME}\t{item.SUBJECT_NAME}\t{item.POINTS}");
                }
            }
        }
コード例 #2
0
 static void CountTest()
 {
     using (var db = new SqliteDbContext())
     {
         var l1 = db.Student.Join(db.Class,
                                  p => p.CLASS_ID,
                                  p => p.CLASS_ID,
                                  (pl, pr) => new { pl.CLASS_ID, pl.STUDENT_ID, pl.STUDENT_NAME, pr.CLASS_NAME });
         var l2 = db.Score.Join(db.Subject,
                                p => p.SUBJECT_ID,
                                p => p.SUBJECT_ID,
                                (pl, pr) => new { pl.SCORE_ID, pl.STUDENT_ID, pl.SUBJECT_ID, pl.POINTS, pr.SUBJECT_NAME });
         var l3 = l1.Join(l2,
                          p => p.STUDENT_ID,
                          p => p.STUDENT_ID,
                          (pl, pr) => new { pl.STUDENT_NAME, pl.CLASS_NAME, pr.SUBJECT_NAME, pr.POINTS });
         foreach (var item in l3)
         {
             Console.WriteLine($"{item.STUDENT_NAME} {item.CLASS_NAME} {item.SUBJECT_NAME} {item.POINTS}");
         }
         //db.JoinTable.Where(p => p.TEST_ID < 10000).ToList();
     }
 }