score:8

Accepted answer

it looks like you are joining data from two different contexts: tms and entities.

this is not possible in linq as both have their own connection to the database and a completely separate model.

it's not possible for ef to convert this into a sql statement. (for all it knows, the tables might live in a different database)

you'd need to either move all your entities to a single context or execute both queries separately and then join them in memory. (use the first option if all tables are in the same db, use the second if you have separate databases)


Related Query

More Query from same tag