Otis wrote:
According to the ADO.NET provider, 'time' is a DateTime:
con.GetSchema("DataTypes");
gives the list of types and the .NET types. There's no other documentation so I have no idea where you did get the info it should be a Timespan? (it would be logical to do, but there's no list of firebird types <-> .NET types anywhere as there's 0.0 documentation shipped with the provider.
As for the documentation, I sponsor Jiri's work a lot because I know that all his work is on almost volountary basis. If I'm not mistaken it is a grant of less than 50€ per month. I'm pretty sure Jiri wouldn't mind documenting it, if somebody would make "time" for it.
That aside, reading the time fields as datetime doesn't work (llblGenPro can't load it) and I know the entity framework loads it (without issues) as a Timespan. These two reasons are the ones why I thought it should be a Timespan.
If I would write a converter, do you have any idea between what types I need to convert? Timespan and ???.
Many thanks
Alexander