tblAttendace
| SerailNo |
EmployeeCode |
Date |
working hour |
| 1 |
x1 |
25/11/2018 |
10 |
| 2 |
x1 |
27/11/2018 |
10 |
| 3 |
x1 |
28/11/2018 |
10 |
tblPayment
| SerailNo |
EmployeeCode |
Date |
Paid |
| 1 |
x1 |
25/11/2018 |
200 |
| 2 |
x1 |
26/11/2018 |
200 |
| 3 |
x1 |
27/11/2018 |
0 |
how to merge in linq like
| SerailNo |
EmployeeCode |
Date |
working hour |
Salary |
| 1 |
x1 |
25/11/2018 |
10 |
200 |
| 2 |
x1 |
26/11/2018 |
0 |
200 |
| 3 |
x1 |
27/11/2018 |
10 |
200 |
| 4 |
x1 |
28/11/2018 |
10 |
0 |
Merge both side table
what if some employee not working on any day but salary paid for those day
and sometime it is work but not paid daily salary,
merge both side table using date using LINQ