Hi Forum,
I've read that it was possible to use LINQ query's to query data from cross reference tables without having to reference the crosstable itself in the linq query. Here is an example:
Table1: Employees
PK: employeeid
Table2: Cross reference between Employees and Roles
FK: employeeid
FK: roleid
Table3:
PK roleid
------------
i would like to query something like
var employees = from e in db.employees.where(e => e.employees.roles.rolename.contains(xxx)..
But i cannot make this work, does anyone has any tips ?
Thanks in advance,
Yuri.
querying many-2-many relations with cross reference table.
-
- Posts: 27
- Joined: Mon 08 Sep 2008 16:37