I've upgraded an old project from 2.6 (.lgp) to a 5.5 (.llblgenproj) project and have trouble with a bunch of tables that have columns of type "time without time zone". The db is PostgreSQL 9.2 In the old project these columns were mapped to System.TimeSpan but now the designer says they are mapped to System.DateTime and i get errors like this:

The mapping of sub-element '[columnnameredacted]' of entity '[tablenameredacted]' for the target database with the driver 'PostgreSql Driver (Npgsql)' has the following errors:

• TypeConverterToUse: The .NET types of the mapped element field and the target field aren't the same/compatible and no implicit conversion is defined by the target framework for these types, so a type converter is needed.

Why does the LLBLGen designer think that these columns should be DateTime and how can I make them TimeSpan?

with a bunch of tables that have columns of type "time without time zone".

Just to be sure, for the PostgreSQL type, do you mean time or timestamp?

ref: https://www.npgsql.org/doc/types/datetime.html

I mean time, not timestamp

Edit: To be extra clear. In INFORMATION_SCHEMA table COLUMNS column data_type the value is "time without time zone".

What version of NpgSql are you usien?

4.0.3.0 is in my GAC, but can i see somewhere in the designer which version it uses?

Ok, figured it out. I made the wrong assumption. Double checked the old 2.6 project and this problem originated from that project. If i removed the entity in the 5.5 project and re-reversed engineered it from db it got correctly mapped to TimeSpan. Sorry to have wasted your time