CODEWITHSUNDEEP
subsonicsubsonic3
CmdrTallen
CmdrTallen

Reputation: 2282

Error with Subsonic attempting to convert Timespan to String

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.

Upvotes: 0

Views: 209

Answers (1)

John Sheehan
John Sheehan

Reputation: 78152

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

Upvotes: 2

Related Questions