[sqlite] .net reading date fields not working?

[eschneider FE]

Hello, 

Having problem reading dates using a data reader. Looks like a bug in
SqLite?

Schema:

CREATE TABLE [Errors] (
        "ErrorId"               integer PRIMARY KEY AUTOINCREMENT NOT NULL,
        "Date"          datetime NOT NULL,
        "Error"         text(2147483647) NOT NULL COLLATE NOCASE

)

Data:
"1"     "5/25/2013 1:18:20 PM"  "Test 333 5/25/2013 1:18:20 PM"
"2"     "5/25/2013 1:18:30 PM"  "Test 333 5/25/2013 1:18:30 PM"


Code:
        Public Shared Function ObtainColumnValue(ByVal column As
DatabaseColumn, ByVal reader As IDataReader) As Object
            If column Is Nothing Then Throw New
ArgumentNullException("column")
            If reader Is Nothing Then Throw New
ArgumentNullException("reader")

            If column.DatabaseColumnIndex <= 0 Then
                Try
                    column.DatabaseColumnIndex =
reader.GetOrdinal(column.DatabaseColumnName)

                Catch ex As IndexOutOfRangeException
                    Throw New DatabaseColumnNotFoundException("Column: " +
column.DatabaseColumnName + " not found for property: " +
column.MappedPropertyName, ex)
                End Try
            End If

            Return reader(column.DatabaseColumnIndex)

        End Function


Error:

Test Name:      TestSimpleQuery
Test FullName:  SqlLiteTestProject.SqlLiteUnitTest.TestSimpleQuery
Test Source:
D:\Dev\FrozenElephant\SymbioticORM\Symbiotic\SqlLiteTestProject_VB\SqlLiteUn
itTest.vb : line 290
Test Outcome:   Failed
Test Duration:  0:00:00.04931

Result Message: 
Test method SqlLiteTestProject.SqlLiteUnitTest.TestSimpleQuery threw
exception: 
System.FormatException: String was not recognized as a valid DateTime.
Result StackTrace:      
at System.DateTime.ParseExact(String s, String[] formats, IFormatProvider
provider, DateTimeStyles style)
   at System.Data.SQLite.SQLiteConvert.ToDateTime(String dateText,
SQLiteDateFormats format, DateTimeKind kind)
   at System.Data.SQLite.SQLite3.GetDateTime(SQLiteStatement stmt, Int32
index)
   at System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt,
SQLiteConnectionFlags flags, Int32 index, SQLiteType typ)
   at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
   at
FrozenElephant.Symbiotic.DataReaderHelper.ObtainColumnValue(DatabaseColumn
column, IDataReader reader) in
D:\Dev\FrozenElephant\SymbioticORM\Symbiotic\Symbiotic\DataReaderHelper.vb:l
ine 147
   at FrozenElephant.Symbiotic.DataReaderHelper.LoadItem[T](T newItem,
IDataReader reader, IList`1 columns) in
D:\Dev\FrozenElephant\SymbioticORM\Symbiotic\Symbiotic\DataReaderHelper.vb:l
ine 102
   at
FrozenElephant.Symbiotic.DataReaderHelper.DataReaderToObject[T](IDataReader
reader, IList`1 columns) in
D:\Dev\FrozenElephant\SymbioticORM\Symbiotic\Symbiotic\DataReaderHelper.vb:l
ine 91
   at
FrozenElephant.Symbiotic.ObjectLoader.ObtainItems[T](IDatabaseTypesFactory
factory, ISqlQuery sql) in
D:\Dev\FrozenElephant\SymbioticORM\Symbiotic\Symbiotic\ObjectLoader.vb:line
468
   at SqlLiteTestProject.SqlLiteUnitTest.TestSimpleQuery() in
D:\Dev\FrozenElephant\SymbioticORM\Symbiotic\SqlLiteTestProject_VB\SqlLiteUn
itTest.vb:line 296

Frozen Elephant Inc.
739 N. Thomphson Dr. #207
Madison, WI 53704
Eric Schneider
(414) 975-3582
eschnei...@frozenelephant.com
www.FrozenElephant.com <http://www.frozenelephant.com/> 


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users