MongoDB C# DateTimeOffset serialization

Question

I'm storing a DateTimeOffset in a Mongo DB using the standard serialization providers.

In the database it looks like this:

{
    "_id" : LUUID("1197f7cf-cb83-4047-85f8-6e9f8c8ad24f"),
    "CreatedDateTimeUtc" : [ 
        6.3612613922066e+017.0, 
        0
    ]
}

But when I try and deserialize in C# the following exception is thrown:

System.FormatException: An error occurred while deserializing the CreatedDateTimeUtc property of class Turnout.Common.Model.Turnout: ReadInt64 can only be called when CurrentBsonType is Int64, not when CurrentBsonType is Double.

Any ideas on how to get it to play nicely?

Answer 1

In the modern ages MongoDB made this a lot easier 😉

BsonSerializer.RegisterSerializer(typeof(DateTimeOffset), new DateTimeOffsetSerializer(BsonType.DateTime));

Afterwards your db entities will have DateTimeOffset serialized like this:

CreatedAt: 2012-01-26T12:15:55.000+00:00