Entity Framework, LINQ: Select Data from tables, crosstables and parenttables
Posted on 2011-05-11
I'm new to this stuff.
I have the following model:
Cocktail 1--m RecipeEntries mc--1 Ingredients
Now I have a CocktailRepository and a Cocktail-Entity.
I need to get all my data for a cocktail, which includes of cource the recipe entries and the ingredients (the name of the ingredients).
But how can I do that, it's easy to select Cocktail and its related RecipeEntries but how do I get the Ingredients?
Should I even do that I one query or not?
I'm using EF4, .NET 4 and C#