Error with Subsonic attempting to convert Timespan to String

Question

Hi, using Subsonic v3.0.0.3 with MS SQL 2008 (10.0.2531) and have two columns in a table 'Date' and 'Time' (not DateTime columns) and when the ActiveRecord SingleOrDefault (line 14110) attempts to load the object (via a given pkid) this error is thrown;

"Object of type 'System.TimeSpan' cannot be converted to type 'System.String'."

Any idea on how to work around this? The part that fuzzles me is MS SQL doesn't have a 'Timespan' column type.

Answer 1

Date and Time column types are not currently supported in SubSonic 3