It seems that "ORDER BY" clause ignored by Butterfly.Core.Database.Memory.SelectRowsAsync() about butterfly-server HOT 4 CLOSED

That's really odd. I'll try it later today and see what his happening. I suspect the problem is unique to MemoryDatabase but I'll see.

from butterfly-server.

It's really nice to hear from you :)

I think you most likely right, this is specific for MemoryDatabase... still, I feel that it either should throw NotImplementedException() exception when it sees ORDER BY or actually do sort the records.

I have another question, do you accept PRs for this project? I run into some limitations of RedHttpServerWebApi. Was able to fix it "outside" of butterfly codebase... but it would be much nicer to have all these throw new NotImplementedException(); taken care of. I would be more than happy to create few PRs to deal with these issues.

Cheers,
Andrei

from butterfly-server.

Yes! I'm actively using Butterfly Server on multiple internal projects but I do not use the RedHttpServer implementation. It doesn't get as much love.

BTW, this line in MemoryDatabase is likely the problem...

DataRow[] dataRows = memoryTable.DataTable.Select(evaluatedWhereClause, null, DataViewRowState.OriginalRows);

The "null" is the parameter for the sort fields...oops. Have to run but this might be an easy fix later today.

from butterfly-server.

Just committed fix

from butterfly-server.