Wrong order when using System.Linq.Dynamic with MongoDB collection

Question

I use System.Linq.Dynamic to order a MongoDB collection.

mongoCollection.AsQueryable().OrderBy("Name ASC");

But the lowercase names gets ordered after the capital cased names, so the items are returned something like this.

I rather expected this:

Is there a way to get the correct order?

Maybe duplicated with [Mongo DB sorting With case insensitive](http://stackoverflow.com/questions/22931177/mongo-db-sorting-with-case-insensitive) — Peyman, Mar 31 '15 at 23:20

score 0 · Answer 1 · answered Mar 31 '15 at 23:19

0

Have you tried

mongoCollection.AsQueryable().ToList().OrderBy(c=>c.Name.ToLower());

answered Mar 31 '15 at 23:19

COLD TOLD

Wouldn't that load all objects in the collection? – Adrian Rosca Mar 31 '15 at 23:21
I guess he wants to order in MongoDB not in memory – Peyman Mar 31 '15 at 23:21
@Peyman, that wouldn't be very practical. What if I have one million objects in the collection? – Adrian Rosca Mar 31 '15 at 23:41
@Adrian, have you checked the link that already added in your question comment? It's duplicate question, you can find your answer in that link – Peyman Mar 31 '15 at 23:43

1 Answers1