I'm migrating a Queue System based on MongDb/C# that I already had in other SQL Databases.
The SQL command that I would like to have something similar is:
UPDATE Orders
SET IsProcessig = true, WorkerName="Worker"
WHERE IsProcessing = false
ORDER BY ProcessingDate
In the orders table, I may have hundreds or thousands of records and to mark the one that will be processed by the worker, he flags the older Order with the worker's name.
In SQL Databases this query works fine, but I can't find a way to do a sorted-list-update in MongoDb.