Databases
StackOverflow2013
Postsdbo
POHow do I navigate through multiple relationships using LINQ to Entities?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I navigate through multiple relationships using LINQ to Entities?
    primarykey
    data
    text
    <p>I'm just starting out with LINQ to Entities, and I'm trying to replicate a search we currently do in a stored procedure as a LINQ to Entities query. However, I can't seem to figure out the correct way to query properties of entities more than one "join" away from the starting point of my query.</p> <p>For example, say I have tables Campaign, CampaignLocation, and Location, which have foreign keys from Campaign to CampaignLocation, and CampaignLocation to Location. Pretty standard many-to-many table configuration. When I start writing my LINQ query like this:</p> <pre><code> var campaigns = from c in context.Campaign.CampaignLocation </code></pre> <p>that's as far in the association chain as I can go. There doesn't seem to be a "Location" property available on "CampaignLocation" so that I can filter on properties of the Location.</p> <p>I tried using the LINQ join syntax like this:</p> <pre><code> var campaigns = from c in context.Campaign join cl in context.CampaignLocation on c.CampaignID equals cl.CampaignID </code></pre> <p>But there doesn't seem to be a "CampaignID" property on the "cl" alias. Which is really weird, there's a column named that on the table. Is it not on the model object since it's the foreign key to the Campaign table?</p> <p>Where am I going wrong here, and what am I missing?</p> <p><strong>[UPDATE]</strong></p> <p>It looks like any integer columns I use for foreign keys are not being added as properties of the model objects. The foreign key relationships are displayed, but the ID properties aren't there. Is there any way to get the designer to add these properties to the model when I read the schema from the database?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBrian Sullivan
    1. USBrian Sullivan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I navigate through multiple relationships using LINQ to Entities?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow do I navigate through multiple relationships using LINQ to Entities?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow do I navigate through multiple relationships using LINQ to Entities?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't know how to prevent it from consuming the relationships as Navigation Properties, i'll do some testing and research and see if I can provide an answer.
      singulars
      1. POHow do I navigate through multiple relationships using LINQ to Entities?
      1. USQuintin Robinson
    2. COEven if I could figure out how to use the navigation properties to travel all the way down to "Location", I'd be fine. I still feel like I'm missing a big part of the picture here.
      singulars
      1. POHow do I navigate through multiple relationships using LINQ to Entities?
      1. USBrian Sullivan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload