Hello, I have the dialect arranging a map between TimeSpan and NodaTime.Duration. I step through several such user type conversions from and to, assembled and disassembled, so I know that at least it should be able to handle the use case.
However, still receiving an exception, not sure quite as to why, maybe something TimeSpan? Nullable is appearing in the ADO recordset somehow, I'm not sure yet. And sorry for the mess here, the excptions, messages, and the query... The data is all there as expected, and have traced up the callstack, up to and including the repository pattern IQueryable query provider, everything else being equal, the values SHOULD be landing in the mapped property(ies) correctly. Trouble is in an exception like this, I do not know per se "which" properties are failing. I'll look at possibly doing some Debug writes at strategic IUserType moments when those details, alias, etc, are better known. Although I'm not sure exactly that will tell me property names, more like the query alias names, which is also not especially helpful. BTW, if it matters, the columns in question, are properly mapped in the context of a fluent Component. This is intentionally properly the case. I'll also have to review the component code, because I'm not hundred percent certain those properties are not internally or privately set, with their values either calculated or ctor provided. Thanks! NHibernate.Exceptions.GenericADOException: 'could not initialize a collection: [WhalleyBotEnhanced.Tracks.TrackMeetEvent.Lanes#c0832da0-d2f9-412c-8364-059f7ed205b5][SQL: SELECT lanes0_.TrackMeetEventId as trackmeeteventid3_10_1_, lanes0_.Id as id1_10_1_, lanes0_.Id as id1_10_0_, lanes0_.Enabled as enabled2_10_0_, lanes0_.TrackMeetEventId as trackmeeteventid3_10_0_, lanes0_.Name as name4_10_0_, lanes0_.Color as color5_10_0_, lanes0_.lowValuePlayerCount as lowvalueplayercount6_10_0_, lanes0_.lowValueDueTime as lowvalueduetime7_10_0_, lanes0_.lowValuePeriod as lowvalueperiod8_10_0_, lanes0_.lowValueDuration as lowvalueduration9_10_0_, lanes0_.highValuePlayerCount as highvalueplayercount10_10_0_, lanes0_.highValueDueTime as highvalueduetime11_10_0_, lanes0_.highValuePeriod as highvalueperiod12_10_0_, lanes0_.highValueDuration as highvalueduration13_10_0_, lanes0_.packCategoriesJson as packcategoriesjson14_10_0_, lanes0_.packIdsJson as packidsjson15_10_0_, lanes0_.positionsJson as positionsjson16_10_0_ FROM public.efcore_wbe_trackmeetlane lanes0_ WHERE lanes0_.TrackMeetEventId=?]' - $exception {"could not initialize a collection: [WhalleyBotEnhanced.Tracks.TrackMeetEvent.Lanes#c0832da0-d2f9-412c-8364-059f7ed205b5][SQL: SELECT lanes0_.TrackMeetEventId as trackmeeteventid3_10_1_, lanes0_.Id as id1_10_1_, lanes0_.Id as id1_10_0_, lanes0_.Enabled as enabled2_10_0_, lanes0_.TrackMeetEventId as trackmeeteventid3_10_0_, lanes0_.Name as name4_10_0_, lanes0_.Color as color5_10_0_, lanes0_.lowValuePlayerCount as lowvalueplayercount6_10_0_, lanes0_.lowValueDueTime as lowvalueduetime7_10_0_, lanes0_.lowValuePeriod as lowvalueperiod8_10_0_, lanes0_.lowValueDuration as lowvalueduration9_10_0_, lanes0_.highValuePlayerCount as highvalueplayercount10_10_0_, lanes0_.highValueDueTime as highvalueduetime11_10_0_, lanes0_.highValuePeriod as highvalueperiod12_10_0_, lanes0_.highValueDuration as highvalueduration13_10_0_, lanes0_.packCategoriesJson as packcategoriesjson14_10_0_, lanes0_.packIdsJson as packidsjson15_10_0_, lanes0_.positionsJson as positionsjson16_10_0_ FROM public.efcore_wbe_trackmeetlane lanes0_ WHERE lane..."} NHibernate.Exceptions.GenericADOException + InnerException {"Unable to cast object of type 'System.TimeSpan' to type 'NodaTime.Duration'."} System.Exception {System.InvalidCastException} -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To unsubscribe from this group and stop receiving emails from it, send an email to fluent-nhibernate+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/fluent-nhibernate/b5ed31b4-e3bb-4f1e-8e74-d6f469f0bbbdn%40googlegroups.com.