DBreeze sorts by ID

[AbdisamadMoh]

Hi DBreeze team, Im very new to dbreeze world and i found it simple, fast and reliable database. Im trying to store users chats, but the problem im facing is that dbreeze seems to sort them my id(ID i used) which i dnt want. Here is the code i used to query using LINQPAD

var db = new DBreeze.DBreezeEngine(@"File");
    using(var tr = db.GetTransaction())
    {
    var s = tr.SelectForward<string, DbMJSON<Message>>("ToAli").Select(x=>x.Value.Get).Dump();

    }
    db.Dispose();

I dont know if approaching in a wrong way, it is sorting by ID. I want the message to be the way they r inserted without any sorting.

Am i doing in a wrong approach? what to do?

[hhblaze]

Hi, you should really start from the docu. DBreeze automatically sorts by inserted key, so if you want records to be sorted by insert sequence use as a key growing up integer 1,2,3. In your case you will need probably minimum two indexes, one is to assure the sorting by adding sequence, second to search by MessageID: use object DBreeze for that. Example is here

[AbdisamadMoh]

Thank you very much. I have one more issue. Should I comment here or create new issue?

[hhblaze]

Thank you very much. I have one more issue. Should I comment here or create new issue?

As you wish

[AbdisamadMoh]

Thank you. I will create new issue, it may help someone else who have same problem.