how to merge both side table in linq

Prince Patel

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Reddy7y ago
where is salary column name in your tabel???
I never found salary name on table
0
Jignesh Kumar7y ago
Hi,

Please try below link,
https://www.mssqltips.com/sqlservertip/3169/understanding-linq-to-join-multiple-tables-where-null-match-are-expected/
0
Kapil Gaur7y ago
Try Something like this
var query = database.Posts
.Join(database.Post_Metas,
post => post.ID,
meta => meta.Post_ID,
(post, meta) => new { Post = post, Meta = meta }) // selection
.Where(postAndMeta => postAndMeta.Post.ID == id);
Just play with this query. Tweak according to your requirement. You will be able to do it.
0