BitBadger.Npgsql.Documents
Advanced Usage: Custom Serialization
JSON documents are sent to and received from PostgreSQL as string
s; the translation to and from your domain objects (commonly called POCOs) is handled via .NET. By default, the serializer used by the library is based on System.Text.Json
with converters for common F# types.
Implementing a Custom Serializer
IDocumentSerializer
(found in the BitBadger.Npgsql.Documents
namespace in both libraries) specifies two methods. Serialize<T>
takes a T
and returns a string
; Deserialize<T>
takes a string
and returns an instance of T
. (These show as 'T
in F#.) While implementing those two methods is required, the custom implementation can use whatever library you desire, and contain converters for custom types.
Once this serializer is implemented and constructed, provide it to the library:
// C# var serializer = /* constructed serializer */; Configuration.UseSerializer(serializer);
// F# let serializer = (* constructed serializer *) Configuration.useSerializer serializer
The biggest benefit to registering a serializer (apart from control) is that all JSON operations will use the same serializer. This is most important for JSON containment queries; the object you pass as the criteria will be translated properly before PostgreSQL compares it.
Uses for Custom Serialization
- If you use a custom serializer (or serializer options) in your application, a custom serializer implementation can utilize these existing configuration options.
- If you prefer
Newtonsoft.Json
, you can wrapJsonConvert
orJsonSerializer
calls in a custom converter. F# users may consider incorporating Microsoft'sFSharpLu.Json
converter. - If your project uses
NodaTime
, your custom serializer could include its converters forSystem.Text.Json
orNewtonsoft.Json
. - If you use DDD to define custom types, you can implement converters to translate them to/from your preferred JSON representation.