EntityDataSource where the number of associations> 0

Question

I am trying to get items that have at least 1 chart, items and charts have 1 to many relationship.

I've tried this:

<asp:EntityDataSource ID="EntityDataSource1" ContextTypeName="Entities"
EntitySetName="Items" Where="Count(it.ItemCharts) > 0" runat="server" />

But I am getting the error:

No overloading of the canonical aggregate function "Edm.Count" is compatible with arg ...

How can I do this without using code?

Thanks for the help!

+3

JoRouss 12 Mar 12 at 17:27

1 answer

nemesv · Accepted Answer · 2012-03-12T21:40:03+0000

You have to use EXISTS to determine if the collection / association is empty:

<asp:EntityDataSource ID="EntityDataSource1" ContextTypeName="Entities"
EntitySetName="Items" Where="EXISTS(it.ItemCharts)" runat="server" />