Breaking News: Grepper is joining You.com. Read the official announcement!

c# entity framework order by array

Fatih KÖSE answered on May 6, 2022 Popularity 2/10 Helpfulness 1/10

answer c# entity framework order by array

c# entity framework order by array

Comment

var countByOtherId = db.EntityToOrder
    .GroupBy(e => e.OtherId)
    .Select(g => new { ID = g.Key, Count = g.Count() })
    .ToDictionary(e => e.ID, e => e.Count);

var other = new Dictionary<long, string>();
int skipCount = startIndex, useCount = 0;
foreach (var e in db.OtherEntity.OrderBy(e => e.Name))
{
    int count;
    if (!countByOtherId.TryGetValue(e.ID, out count)) continue;
    if (skipCount > 0 && other.Count == 0)
    {
        if (skipCount >= count) { skipCount -= count; continue; }
        count -= skipCount;
    }
    other.Add(e.ID, e.Name);
    if ((useCount += count) >= pageSize) break;
}


var entities = db.EntityToOrder
    .Where(e => other.Keys.Contains(e.OtherId))
    .AsEnumerable()
    .Select(e => new EntityToOrder { ID = e.ID, Name = e.Name, 
        OtherId = e.OtherId, OtherName = other[e.OtherId] })
    .OrderBy(e => e.OtherName).ThenBy(e => e.Name)
    .Skip(skipCount).Take(pageSize)
    .ToList();

Popularity 2/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# entity-framework

Link to this answer
Share Copy Link

Contributed on May 06 2022

Fatih KÖSE

0 Answers Avg Quality 2/10

c# entity framework order by array

Contents

More Related Answers

c# entity framework order by array

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.