for the write mapping.
{System.InvalidCastException: Can't write CLR type System.DateTimeOffset with handler type TimestampHandler
at Npgsql.TypeHandling.NpgsqlSimpleTypeHandler`1.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter) in C:\projects\npgsql\src\Npgsql\TypeHandling\NpgsqlSimpleTypeHandler.cs:line 236
at Npgsql.NpgsqlParameter.ValidateAndGetLength() in C:\projects\npgsql\src\Npgsql\NpgsqlParameter.cs:line 553
at Npgsql.NpgsqlCommand.ValidateParameters() in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 793
at Npgsql.NpgsqlCommand.<ExecuteDbDataReader>d__100.MoveNext() in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1140}
INSERT INTO "Logs" ("Message", "MessageTemplate", "Level", "RaiseDate", "Exception", "Properties", "PropertyTest", "IntPropertyTest", "MachineName") VALUES (@Message, @MessageTemplate, @Level, @RaiseDate, @Exception, @Properties, @PropertyTest, @IntPropertyTest, @MachineName)
Parameters:
DbType, Value, .Net type, NpgsqlType
String, "Test0: TestObjectType1 { IntProp: 42, StringProp: "Test" } test2: TestObjectType2 { DateProp: 05/12/2019 18:21:41, NestedProp: TestObjectType1 { IntProp: 42, StringProp: "Test" } } testStr: stringValue", string, Text
String, "Test{testNo}: {@testObject} test2: {@testObj2} testStr: {@testStr:l}", string, Text
String, "Information", Enum, Varchar
DateTime, 12.05.2019 18:21:41 +02:00, DateTimeOffset, Timestamp
String, {}, DbNull, Text
Object, "{"Timestamp":"2019-05-12T18:21:41.2106317+02:00","Level":"Information","MessageTemplate":"Test{testNo}: {@testObject} test2: {@testObj2} testStr: {@testStr:l}","Properties":{"testNo":0,"testObject":{"_typeTag":"TestObjectType1","IntProp":42,"StringProp":"Test"},"testObj2":{"_typeTag":"TestObjectType2","DateProp":"2019-05-12T18:21:41.1639858+02:00","NestedProp":{"_typeTag":"TestObjectType1","IntProp":42,"StringProp":"Test"}},"testStr":"stringValue","MachineName":"MyPC"},"Renderings":{"testStr":[{"Format":"l","Rendering":"stringValue"}]}}\r\n", string, Jsonb
String, "{"testNo":0, "testObject":{"IntProp":42,"StringProp":"Test","_typeTag":"TestObjectType1"}, "testObj2":{"DateProp":"2019-05-12T18:21:41.1639858+02:00","NestedProp":{"IntProp":42,"StringProp":"Test","_typeTag":"TestObjectType1"},"_typeTag":"TestObjectType2"}, "testStr":"stringValue", "MachineName":"MyPC"}", string, Text
Int32, 0, int, Integer
String, "MyPC", string, Text