MongoDB, C# and DateTimeOffset

PublishedSeptember 20, 2017

•2 min read•View as Markdown

Søren Kruse

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Dynamic caching policy with Polly

Polly is great library for easily configuring different kinds of policies around code execution, be it retry, circuit breaker, caching or lots of other things. It's probably most often used around HTTP requests. If you haven't heard about it you defi...

Jan 15, 20213 min read

Unit Testing - Part 2: Naming, structure and readability

This is part 2 of my series on unit testing in .NET (C#) and will be about my conventions regarding naming unit tests, how to structure them and which parts to test. And lastly I will help you increase readability of assertions and potential error me...

Jan 9, 20217 min read

Unit Testing - Part 2: Naming, structure and readability

Unit Testing - Part 1: Getting started with unit tests in .NET

I feel like unit testing is very important and very beneficial in a lot of ways. It helps with not breaking existing functionality and thereby also making you more confident in changing code without fear of breaking important stuff. Often it also mak...

Dec 28, 20207 min read

Unit Testing - Part 1: Getting started with unit tests in .NET

Getting NSwag to work behind reverse proxy

I've been working with Swagger through NSwag a lot recently and also needed to get it to work when hidden behind a reverse proxy - i.e. another service forwarding a request to the service exposing the Swagger UI. Some of the issues I've had along the...

Dec 18, 20202 min read

Getting NSwag to work behind reverse proxy

NSubstitute - make async method (Task) throw an exception

The other day I was writing a unit test to verify what was supposed to happen when a Task would throw an exception when awaited. It wasn't as straight forward as I first assumed, but I quickly found this Stack Overflow post that helped me: https://st...

Dec 12, 20203 min read

NSubstitute - make async method (Task) throw an exception

Søren Kruse | .NET, C# and Azure

51 posts

Array representation (default)

By default DateTimeOffset is serialized as an array consisting of the ticks and the offset in minutes.

// Serialization code for BsonType.Array bsonWriter.WriteStartArray(); bsonWriter.WriteInt64(value.Ticks); bsonWriter.WriteInt32((int)value.Offset.TotalMinutes); bsonWriter.WriteEndArray(); // Example JSON output // [NumberLong("636415154304356493"), 120]

This is probably the reason you are here right now. This is different than DateTime which is stored as a BSON date (ISODate("2017-09-20T12:46:53.552Z")) and it makes it harder to query manually and harder to read.

I'm sure there's a good reason why this was made the default, but I'm not exactly sure why.

Document representation

The last of the three options is the document representation, which is more or less a combination of the array and string representation combined in an object (document).

// Serialization code for BsonType.Document bsonWriter.WriteStartDocument(); bsonWriter.WriteDateTime("DateTime", BsonUtils.ToMillisecondsSinceEpoch(value.UtcDateTime)); bsonWriter.WriteInt64("Ticks", value.Ticks); bsonWriter.WriteInt32("Offset", (int)value.Offset.TotalMinutes); bsonWriter.WriteEndDocument(); // Example JSON output // { // "DateTime": ISODate("2017-09-20T12:56:06.642Z"), // "Ticks": NumberLong("636415161666429142"), // "Offset": 120 // }

Command Palette

Comments

More from this blog

Array representation (default)

String representation

Document representation