Entity Framework 6 - Knowledge Base (KB)

Linq OrderBy breaks with navigation property being null

Working with four tables....Users -> has basic user info including a userid and a departmentid (int)... Groups -> basic group info including a groupid... GroupsMembers -> table that has the relationship between a group and it's members, many to many relat...

Ordering Entity Framework items and child items for MVC view

How can I sort a query from a DbSet and include child items which should also be sorted....Example:...I have a model for scheduling orders....public class Order { public virtual int Id { get; set; } public virtual int? SchedulingOrder { get; set; } ...

LINQ OrderBy not ordering .. changing nothing .. why?

Any idea why the LINQ OrderBy is not working in following code, (have no errors but method does not sort ...)...First my own type...public class IQLinksView { public int id { get; set; } public int catid { get; set; } public in...

Entity Framework ORDER BY issue

I'm attempting to build my first MVC 4 application using the entity framework. All I'm looking for is to create a drop down list with the value and text of each option set to the same value. ...This works, right up until I throw in the ...GroupBy().......

How to use OrderBy in EntityFramework

I have a table named ...Person... with two columns: (PersonId - key, ...PersonName...)...I'm trying to retrieve all persons ordered by ...PersonName.......The following code does NOT order my result:...var persons = from p in MyContext.Persons.OrderBy(x=>...