Structure Table use Sqlite net pcl and LINQ

Question

Structure Table use Sqlite net pcl and LINQ

gembel_abadi 41

How do I make the Attendance table structure by joining the table as shown above?
Nb.
I have 2 class. program and student, I like joined table in Absensi class but I don't know how to make it.
because Date from Program class and Name from Student class.

Nicole Lu-MSFT 96 Reputation points Microsoft Employee

2021-02-24T02:46:01.363+00:00

Hi @gembel_abadi not quite understand what you're trying to do, are you saying that you have tables for Program and Student, and need to have another table to record the attendance info for which student joined which program? Usually for this scenario, it's better to have a relationship table like:
]
which will record which student joined which program.

Also, please make some elaboration on the "Checklist", I'm not able to help you org your table without knowing the meaning of the items.

Nicole Lu-MSFT 96 Reputation points Microsoft Employee

2021-02-24T02:46:01.363+00:00

Hi @gembel_abadi not quite understand what you're trying to do, are you saying that you have tables for Program and Student, and need to have another table to record the attendance info for which student joined which program? Usually for this scenario, it's better to have a relationship table like:
]
which will record which student joined which program.

Also, please make some elaboration on the "Checklist", I'm not able to help you org your table without knowing the meaning of the items.

Structure Table use Sqlite net pcl and LINQ

Activity