querying many-2-many relations with cross reference table.

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
[email protected]
Posts: 27
Joined: Mon 08 Sep 2008 16:37

querying many-2-many relations with cross reference table.

Post by [email protected] » Wed 18 Feb 2009 15:57

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.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 24 Feb 2009 11:32

This scenario is not supported yet. We plan to support it, but no timeframe can be provided.

Post Reply