Trying join table process_log and table visit but didnt show a data
personal is the relationship column
mapping
Table("process");
Id(x => x.process_date, "date");
Map(x => x.personal_id, "personal");
Map(x => x.exam_started_on, "started_on");
Join("visit ", v =>
{
v.Fetch.Join();
v.KeyColumn("personal");
v.Map(t => t.record_id, "record_id");
});
dateexameList = session.CreateCriteria<DateExamLog>()
.Add(Expression.Eq("started", Examdate))
.Add(Expression.Or(
Expression.Eq("personal", nric),
Expression.IsNull("personal")))
.CreateCriteria("Patron", "patron", JoinType.LeftOuterJoin)
.CreateCriteria("personal", "personal", JoinType.LeftOuterJoin)
.List<DateExamLog>();
What I have tried:
I try google but can not find wat is worng