Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is a solution which requires only a single roundtrip:</p> <pre><code>var orders = Context.Orders .Select(o =&gt; new { Order = o, SubOrderBases = o.SubOrderBases.Where(s =&gt; !(s is MyOrder)), MyOrdersWithCustomers = o.SubOrderBases.OfType&lt;MyOrder&gt;() .Select(m =&gt; new { MyOrder = m, Customers = m.Customers }) }) .ToList() // &lt;- query is executed here, the rest happens in memory .Select(a =&gt; { a.Order.SubOrderBases = new List&lt;SubOrderBase&gt;( a.SubOrderBases.Concat( a.MyOrdersWithCustomers.Select(m =&gt; { m.MyOrder.Customers = m.Customers; return m.MyOrder; }))); return a.Order; }) .ToList(); </code></pre> <p>It is basically a projection into an anonymous type collection. Afterwards the query result is transformed into entities and navigation properties in memory. (It also works with disabled tracking.)</p> <p>If you don't need entities you can omit the whole part after the first <code>ToList()</code> and work directly with the result in the anonymous objects.</p> <p>If you must modify this object graph and need change tracking, I am not sure if this approach is safe because the navigation properties are not completely set when the data are loaded - for example <code>MyOrder.Customers</code> is <code>null</code> after the projection and then setting relationship properties in memory could be detected as a modification which it isn't and cause trouble when you call <code>SaveChanges</code>.</p> <p>Projections are made for readonly scenarios, not for modifications. If you need change tracking the probably safer way is to load full entities in multiple roundtrips as there is no way to use <code>Include</code> in a single roundtrip to load the whole object graph in your situation.</p>
    singulars
    1. This table or related slice is empty.
    1. POEntity Framework - Eager loading of subclass related objects
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSlauma
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POEntity Framework - Eager loading of subclass related objects
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks! very interesting solution! Not exactly what i wanted, but i think this example will be a great inspiration
      singulars
      1. PO
      1. USGopher
    2. COGreat answer but what a remarkably daft way of having to do things. Anyone would think that the EF team overlooked the fact that relational databases have relationships between tables.
      singulars
      1. PO
      1. USIan Warburton
 

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