开发者

How to sort inner list that is returned by entity framework?

开发者 https://www.devze.com 2023-01-21 04:23 出处:网络
How do I sort the inner collection of an object returned by the entity framework? public class X { public string Field {get; set;}

How do I sort the inner collection of an object returned by the entity framework?

public class X
{
   public string Field {get; set;}
   public EntityCollection<Y> Ys {get; set;}
}

public class Y
{
   pu开发者_高级运维blic string Field {get; set;}
}

from x in entities.Xs
orderby x.Field
select x

Is there a way to modify this LINQ query to return the X objects and also have the Y objects sorted? Or do I have to manually sort the Y list when it comes back?

EDIT:

This code must return a collection of X typed objects, anonymous typing doesn't meet the current project's requirements.


var sortedList = from x in entities.Xs
                 orderby x.Field
                 select new {
                   Field = x.Field,
                   y = (select y in x.Ys
                        orderby y.Field
                        select y)
                 };

Edited: If you don't want anonymous types then do this:

var sortedList = from x in entities.Xs
                 orderby x.Field
                 select new X {
                   Field = x.Field,
                   y = (select y in x.Ys
                        orderby y.Field
                        select y)
                 };
0

精彩评论

暂无评论...
验证码 换一张
取 消