Unable to cast object of type 'MongoDB.Bson.BsonDecimal128' to type 'MongoDB.Bson.BsonBoolean'
I had an issue with sorting my collection by a decimal value that I've inserted into a MongoDB database with the decimal type.
Shortly after I've realized that the MongoDB driver converted the value wrong; in the database the value gets falsely converted into a string and that's why the sorting doesn't work.
So, I've tried using the BsonDecimal128 type to insert it into the database. That works perfectly in the database and shows as a Decimal128! The sorting also worked correctly when testing it out in MongoDBCompass.
But, once I tried to connect to the Swagger UI to test the shell queries, it freezes and there's a browser popup saying that the page is slowing down my browser. That hasn't happened before.
When I try it via the URL I get the error message InvalidCastException: Unable to cast object of type 'MongoDB.Bson.BsonDecimal128' to type 'MongoDB.Bson.BsonBoolean'.
How do I fix this?
Okay, so I found a workaround. I converted the calculated decimal value into a double and it seems to do the trick:
Value = Convert.ToDouble(value)
It's better to avoid decimal as long as double works too.
- When did C allow casting constants and variables to struct for assignment?
- Why in C can I initialize more values than the size of an array?
- Using c to create a file and write+read to it, what went wrong?
- Does write system call need the data to be read to give >-1 return?
- Difference between fgetc() and read() function in C
- How can I get to know the IP address for interfaces in C?
- read fails with EFAULT
- In this case, how to achieve modularity and information hiding at the same time?
- Are global variables always initialized to zero in C?
- OpenGL function calls seemingly affecting unrelated data
- What Values of Variables x and y Will Produce Incorrect Results When Testing for Overflow After Subtraction of x-y in the Following Program?
- How to write a general-type queue library in c?
- Which gcc and g++ version support which standard of c and c++?
- How to dereference a member in a struct whose definition is not visible?
- How to name a type in a meaningful way?
- What are Vectors and < > in C?
- Why does 1.0/100.0 == 0.1/10.0 give True?
- How to organize the receive msg and user current input in C network such that it's clean
- Using inclusive scan syntax in OpenMP in the C language
- Unable to understand context in book "OOP in C" by Axel Schreiner
- variable-length array in struct with TI compiler in C (socket programming)
- A faster way to test 32bpp DDBs for a valid Alpha channel
- How can I compile the zephyr example-application as a freestanding application?
- Why does my forked process sometimes overwrite data in a file?
- _Generic in C needs typecasting?
- Declaring/defining an unused variable changes the output from an unrelated variable
- How to use gdb to explore the stack/heap?
- How can I read an input string of unknown length?
- Confused by difference between expression inside if and expression outside if
- Fast Arc Cos algorithm?