Why doesn't DevExpress XPO support the SQL Server time(7) datatype? Does anyone know about that?

Here's some articles. But I don't understand how double precision converted to TimeSpan?

https://docs.devexpress.com/XPO/400478/product-information/data-types-supported-by-xpo/mssql-data-types-mapping

When I use time(7) datatype for my column, this exception is thrown:

DevExpress.Xpo.DB.Exceptions.PropertyTypeMappingMissingException:
'Database provider cannot process the 'System.Object' type because it is not mapped to the types of an underlying database. Please use another type.'

Here's a screenshot showing the datatype mappings. I don't understand what is difference?

Does they mean TimeSpan.FromSeconds(double) ?

The DBColumn.GetType(Column.ColumnType) of the Time column returns System.Object.

Any help with that....

https://stackoverflow.com/questions/67352657/why-doesnt-devexpress-xpo-support-the-sql-server-time7-datatype-does-anyone May 02, 2021 at 11:10AM