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

where is salary column name in your tabel??? I never found salary name on table

Hi, Please try below link, https://www.mssqltips.com/sqlservertip/3169/understanding-linq-to-join-multiple-tables-where-null-match-are-expected/

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.

Answers

how to merge both side table in linq

Prince Patel

495

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