I am facing a problem in populating datagrid using linq.
I have three tables:
Table1, Table2, Table3
Table1 has columns : date, machine_name
Table2 has columns : date, machine_name, defect
Table3 has columns : date, machine_name, status
1. In service.svc, I am not able to join these three table on basis of date
Table1: date | machine_name
1/1/2012 | AAAA
2/1/2012 | BBBB
Table2: date | machine_name | defect
1/1/2012 | AAAA | gear break
2/1/2012 | BBBB | shaft break
2/1/2012 | BBBB | spline break
Table3: date | machine_name | status
1/1/2012 | AAAA | not working
2/1/2012 | BBBB | still working
After Joining Final table should display result:
Table1 Table2 Table3
date | machine_name | defect | status
1/1/2012 | AAAA | gear break | not working
2/1/2012 | BBBB | shaft break | still working
2/1/2012 | BBBB | spline break | still working
2.) How to use collection and how to specify return type so it could be bind to datagrid
Thanks
Raman