Databases
StackOverflow2013
Postsdbo
POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
    primarykey
    data
    text
    <p>I've got a scenario where I will need to order by on a column which is a navigation property for the Users entity inside my EF model.</p> <p>The entities: Users --> Countries 1:n relationship</p> <p>A simple SQL query would be as follows:</p> <pre><code>SELECT UserId, u.Name, c.Name FROM users u join countries c on u.CountryId = c.CountryId ORDER BY c.Name asc; </code></pre> <p>So then I tried to replicate the above SQL query using Linq to Entities as follows - (Lazy Loading is enabled)</p> <pre><code>entities.users.OrderBy(field =&gt; field.country.Name).ToList(); </code></pre> <p>But this query does not return my countries sorted by their name as the native SQL query above does.</p> <p>However I continued a bit more and did the following:</p> <pre><code>var enumeratedUsers = entities.users.AsEnumerable(); users = enumeratedUsers.OrderBy(fields =&gt; fields.country.Name).ToList(); </code></pre> <p>But ordering on the enumeratedUser object for about 50 records took approx. 7seconds</p> <p>Is there a better way how to omit the Enumerable and without returning an anonymous type?</p> <p>Thanks</p> <p><strong>EDIT</strong></p> <p>I just forgot to say that the EF provider is a MySQL one not a MS SQL. In fact I just tried the same query on a replicated database in MS SQL and the query works fine i.e. the country name is ordered correctly, so it looks like I have no other option apart from getting the result set from MySQL and execute the order by from the memory on the enumerable object</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRyan
    1. USRyan
    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. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
      1. USdkroy
      1. VTFavorite
    1. COYou don't have an anonymous type. var keyword in your case simply hides the IEnumerable<TEntity> type, where TEntity is your Users entity type. The entities.users is an EntityCollection (if I understood your EF model right) already implements the IEnumerable, so you can safely use entities.users.OrderBy(f => f.country.Name).ToList(); However, like Dennis said, you must include all wanted entity associations.
      singulars
      1. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
      1. USKornelije Petak
    2. COBut that does not return the county names sorted unfortunately
      singulars
      1. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
      1. USRyan
    3. COTry to see if you can get anything from this link. http://thejoyofcode.com/Sorting_associations_in_the_Entity_Framework.aspx
      singulars
      1. POOrder by a field which is a Navigation Property to an Entity - Linq to Entity
      1. USKornelije Petak
 

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