Question

我使用与实体框架4.1有关的周转基金数据服务。

I have 2 tables with many to many relationship. I m trying to get an entity based on a child value.

Table 1 (Suppliers) -> ID (PrimaryKey) ,Name ,isEnabled ,Timestamp
Table 2 (Categories) -> RGID (PrimaryKey) , Name, etc....

I ve tried to to write the URI like this. My goal is to retrieve all Suppliers that has a Category with RGID = 3.

http://localhost/WCFS/WCFService.svc/Suppliers?$expand=Categories&$filter=RGID eq 3

像这样

   http://localhost/WCFS/WCFService.svc/Suppliers?$expand=Categories&$filter=Categories/RGID eq 3

no luck. for the second attampt I get

The  RGID   is not allowed at position 11. Member access or specifying a type identifier on a resource set reference is not allowed.

怎么办?

感谢谢谢

Answer 1

使用导航:

~/Categories(3)/Suppliers