Entity Framework 6 - Knowledge Base (KB)

When the navigation property is null, Linq OrderBy fails.

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...

MVC view order of Entity Framework elements and child things

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; } ...

Order LINQ Why are you not ordering... altering nothing...?

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=>...