CODEWITHSUNDEEP
entity-frameworklinq-to-entities
Asmussen
Asmussen

Reputation: 468

Entity Framework linq query

I need help formatting my link query properly, I am using EF 3.5:

Dim mediators = (From m In entity.Mediators _
                 Where m.MediatorAvailabilities.Available = "Weekends"
                         Where (m.isActive = True) _
                        Order By m.Sequence _
                        Select New RankingCriteria() With { _
                            .FirstName = m.FirstName, _
                            .LastName = m.LastName, _
                            .CompanyName = m.CompanyName, _
                            .PhoneHome = m.PhoneHome, _
                            .PhoneWork = m.PhoneWork, _
                            .PhoneMobile = m.PhoneMobile, _
                            .Email = m.Email _
                        }).ToList()

I have a navigation property in Mediators to MediatorAvailabilities I want to do something like what is in where clause above in order to filter my results. It's not letting me navigate to the appropriate column by doing this: m.MediatorAvailabilities.Available.

How do I do this filter properly?

Thanks, Justin.

Upvotes: 1

Views: 260

Answers (1)

Aducci
Aducci

Reputation: 26634

You will need to use the Any method. I dont know the proper VB syntax, but it should look something like this:

Where m.MediatorAvailabilities.Any(ma => ma.Available = "Weekends")

Upvotes: 1

Related Questions