Fetch and sort data from DB in ASP.NET Core Web Api

Question

Suppose I have some data like:

I want to fetch data in an order like, first give me all with IsActive == true and sort it in an alphabetical order by account name and then the false one sorted by account name.

How can I do it by _context.table.OrderBy() or some other method?

Does this answer your question? [C# List<> Sort by x then y](https://stackoverflow.com/questions/289010/c-sharp-list-sort-by-x-then-y) — Armend Ukehaxhaj, Jun 09 '20 at 11:28
[this](https://stackoverflow.com/questions/5408177/linq-order-by-boolean) along with your comment @viveknuna helped me, how can I close the question? — Mansi, Jun 09 '20 at 11:40

score 0 · Accepted Answer · answered Jun 09 '20 at 11:44

0

You have to use OrderBy on IsActive and then ThenBy on AccountNameto sort the records.

answered Jun 09 '20 at 11:44

Vivek Nuna

25,472
25
109
197

Fetch and sort data from DB in ASP.NET Core Web Api

1 Answers1