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}");
}
}
}
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}");
}
}
}