Filter on collections

[Madhu]

 

I have a persistent class PhysicalResourceSpecAtomic  and another persistent class PhysicalResourceSpecComposite
 which has a variable CaptivePhysicalResourceSpecCollection which is persistent
 which has a collection of PhysicalResourceSpecAtomic
and I have definde the collection to be in a association table as 1:n

Now I want to get a list of PhysicalResourceSpecAtomic 
  which are not in collection CaptivePhysicalResourceSpecCollection.

Thanks
Madhu Rao

[Damyan Bogoev]

Hi Madhu,

You could use the IList.Contains(object) method to determine whether the CaptivePhysicalResourceSpecCollection contains a specific value:

IList<PhysicalResourceSpecAtomic> resultList = context.PhysicalResourceSpecAtomicEndPointName.Where(x => !physicalResourceSpecComposite.CaptivePhysicalResourceSpecCollection.Contains(x));

Hope that helps.

Regards,
Damyan Bogoev
the Telerik team

[Madhu]

Damyan,
I am using Scope.Extent to generate the sql. Also what is the "EndPointName appended at the end of the class PhysicalResourceAtomic. Can you send me the syntax in vb.net.

Thanks
Madhu Rao

[Damyan Bogoev]

Hi Madhu,

The filter query syntax in VB.NET is:

Dim resultList As IEnumerable(Of PhysicalResourceSpecAtomic) = scope.Extent(Of PhysicalResourceSpecAtomic)().Where(Function(x) Not physicalResourceSpecComposite.CaptivePhysicalResourceSpecCollection.Contains(x))

An endpoint is an IQueryable collection exposed by the OpenAccessContext which allows accessing the instances of the corresponding persistent capable type.
Hope that helps.

Regards,
Damyan Bogoev
the Telerik team