I have this code:
namespace TA_SCOREBOARD_DATA
{
public class TA_Scoreboard_Classcs
{
SQL_TA_SCOREBOARDEntities1 contxt = new SQL_TA_SCOREBOARDEntities1();
public List<String> EmployeeAccess2()
{
EmployeeAccess EA = new EmployeeAccess();
View_HCM VH = new View_HCM();
var x = from a in EA
join b in VH on a.EmpNo equals b.EmpNo
select new
{
a.EmpNo,
b.EmailAddress
};
return x.ToList();
}
}
}
*I'm getting these errors under:*
-- EA (from a in EA):
'Could not find an implementation for the query pattern...'
-- x.**ToList**();
'The type arguments for method 'System.Linq...IEnumerable<tsource>' cannot be inferred from the usage. Try specifying the type arguments explicitly.'
*WHERE:*
-- EmployeeAccess is a table (with *id* and *EmpNo* columns, *EmpNo* with 3 data)
-- View_HCM is a view (with *EmailAddress*, *EmpNo* columns and 1000+ data)
-- No IntelliSense under b.EmpNo
-- using *edmx, dbml* objects
-- already using System.Data namespaces
How do I "inner join" the 3 EmpNo in EmployeeAccess according to View_HCM EmpNo with EmailAddress?