Many to Many subquery in Entity Framework RRS feed

  • Question

  • Been slamming by head against the wall for 6 hours on this one.

    Here is a really simple SQL query:

    select * from LocationVenue
     where exists
       (select *
          from LocationVenueAttributeValue

    where LocationVenueID = 1

      and Attribute = 1

      and AttributeValue in (1, 2, 3))

    I cannot figure out how to do this in entity framework.

    Please help!

    • Edited by octapi Monday, July 15, 2013 6:53 PM
    Sunday, June 30, 2013 10:29 PM

All replies

  • Hi octapi;

    How are you associating selected values from the select in the where and the outer select?


    Fernando (MCSD)

    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

    NOTE: If I ask for code, please provide something that I can drop directly into a project and run (including XAML), or an actual application project. I'm trying to help a lot of people, so I don't have time to figure out weird snippets with undefined objects and unknown namespaces.

    Monday, July 1, 2013 12:14 AM