I have a table called `Recipes` which contain one recipe per row. I also have a table called `RecipeIngredients` which contain one ingredient as used by a particular recipe. Thus, each `Recipe` row has one or more children `RecipeIngredients` rows.
What I'm trying to do is create a query to find all recipes that contain any ingredients in a list of desired ingredients. For example, show me all recipes that use either flour, eggs, or bananas. The SQL would look something like this: SELECT * FROM Recipes r WHERE EXISTS (select 1 from RecipeIngredients where RecipeId = r.RecipeId and IngredientId = ANY (5, 10, 15) limit 1); However, I'm having a tough time figuring out how to express this as a LINQ query, or using the QueryOver<T> method. I don't want to hard code in the SQL since this needs to be database agnostic and I want the configured NHibernate dialect to generate the correct code. Any ideas? -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/groups/opt_out.
