StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUpdating numerical types using NoRM and other tools changes numerical type metadata on MongoDb
text
Body
copied!<p>We are using the NoRM C# driver to store our domain classes on mongodb. The problem we are facing is regarding external updates on this database. When trying to update an existing domain entity created originally using NoRM using an external tool such as mongo shell or MongoVUE numeric values are stored as different numeric types. Ie: domain entities containing Int32 field values are updated as integer64 (MongoVUE) or float64 (mongo Shell).</p> <p><strong>Original C# Entity:</strong></p> <pre><code>Class Person { public string Name {get; set;} public int Age {get; set;} } </code></pre> <p><strong>Original Entity created using NoRM:</strong></p> <pre><code>{ Name: 'John Smith', Age: 16 } // On MongoVUE Age field is shown as Int32 </code></pre> <p><strong>Updated entity using MongoVUE:</strong> </p> <pre><code>db.Test.update({Age:16}, {$set:{Age:22}}) { Name: 'John Smith', Age: 22 } // On MongoVUE Age field is shown as Int16 </code></pre> <p><strong>Update Entity using Mongo Shell:</strong> </p> <pre><code>db.Test.update({Age:22}, {$set:{Age:32}}) { Name: 'John Smith', Age: 32 } // On MongoVUE Age field is shown as Float64 </code></pre> <p>When we try to retrieve an updated entity using NoRM depending on the tool used to perform the update NoRM fails to retrieve the entity.</p> <p>So we need to specify somehow the numeric type metadata on the update query, but we’ve found no way to do it.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload