Re: Need some LINQ love

[Steve Gerrard]

Roshawn wrote:

Hi,

'error happens on the line below
brands = db.Brands.Where(Function(b) b.Products(0).Merchant.name =
myMerchant AndAlso b.Products.Count 0).ToList
This code totally bombed. A System.NotSupportedException is thrown,
stating, "Method 'Product get_Item(Int32)' has no supported
translation to SQL"

I could be way off, so take this with a grain of salt.

I would first remove the (0) after Products; then I would specify a property for
myMerchant, i.e. name.

That would give
brands = db.Brands.Where( _
Function(b) b.Products.Merchant.name = myMerchant.name _
AndAlso b.Products.Count 0 _
).ToList

I don't know if it is valid LINQ, but it makes more sense to me, anyway.

[Roshawn]

Thanks for the reply, Steve. Sorry I took so long to respond but I've been busy with
other things...

As for the code you provided, it didn't work. When I remove the "(0)" after Products, all
Intellisense gives me are properties and methods associated with EntitySet(Of Product).
There is no mention of the Merchant EntitySet anywhere.

But thanks anyway. I'll keep trying, and when I get it, I'll share it here.