コード例 #1
0
ファイル: Program.cs プロジェクト: arvindks93/MLGCentral
 static void TestForDAL()
 {
     using (var db = new CADBContext())
     {
         var cases     = db.Cases;
         var casetypes = db.CaseTypes;
         var query     = from c in cases
                         join ct in casetypes on c.case_type_id equals ct.case_type_id
                         where c.case_type_id == 11 && c.create_dt > DateTime.Parse("05/01/2018")
                         select new
         {
             case_num = c.case_num,
             type     = ct.name,
             c.create_dt
         };
         foreach (var item in query)
         {
             Console.WriteLine($"case number: {item.case_num}, case type: {item.type}, create date: {item.create_dt}");
         }
     }
 }
コード例 #2
0
ファイル: Program.cs プロジェクト: arvindks93/MLGCentral
        static void Test()
        {
            using (var db = new CADBContext())
            {
                var casetype  = db.CaseTypes;
                var cases     = db.Cases;
                var sequences = db.Sequences;
                var query     = from c in cases
                                join types in casetype on c.case_type_id equals types.case_type_id
                                join seq in sequences on c.case_seq_id equals seq.case_seq_id
                                where c.create_dt > DateTime.Parse("05/01/2018") && types.case_type_id == 11
                                select new
                {
                    caseNum = c.case_num, typeName = types.name, seqNme = seq.name, c.create_dt
                }
                ;

                foreach (var item in query)
                {
                    Console.WriteLine($"case_num: {item.caseNum} --caseType: :{item.typeName} - seqName: {item.seqNme} -- {item.create_dt}");
                }
            }
        }