Problem with "time without timestamp" data type
Posted: Fri 20 Jan 2006 17:10
Hi folks
Running a trial on PostgreSQLDirect and have run into an early problem.
I'm using the DataAdaptor to fill an untyped DataSet.
PG "date" fields are being handled OK. But "time without timestamp" fields are all being loaded as C# type System.TimeSpan with the value 00:00:00.
This is happening with my own code, and when I run the CoreLab DataSet demo. I've tried running FillSchema before running Fill, but this hasn't helped.
I'm very new to ADO.Net, so perhaps I'm misunderstanding something. I'd appreciate any pointers. We're planning to make a purchase, provided we can get things working OK.
Geoff
Running a trial on PostgreSQLDirect and have run into an early problem.
I'm using the DataAdaptor to fill an untyped DataSet.
PG "date" fields are being handled OK. But "time without timestamp" fields are all being loaded as C# type System.TimeSpan with the value 00:00:00.
This is happening with my own code, and when I run the CoreLab DataSet demo. I've tried running FillSchema before running Fill, but this hasn't helped.
I'm very new to ADO.Net, so perhaps I'm misunderstanding something. I'd appreciate any pointers. We're planning to make a purchase, provided we can get things working OK.
Geoff