System.Data.SQLite

Ticket Change Details
Login
Overview

Artifact ID: 43e1c341b61fe0c505b48a49fcdb13b46af93f86
Ticket: c6397ed60e34a015a052892aa6ce7bd94366278a
The string was not recognized as a valid DateTime at timestamp
User & Date: anonymous 2020-04-24 13:31:04
Changes

  1. foundin changed to: "1.0.112"
  2. icomment:
    By reading from a table with column with TIMESTAMP (byte[] 8 bytes) the program throws the error
    "The string was not recognized as a valid DateTime"
    
    All in this Project:
    https://cloud.webnworkls.selfhost.eu/s/qsSMFCX3FJ5aNyg
    ConsoleSqLiteTest.zip
    
    Table SQL
    CREATE TABLE Artikel
    (
    ARTIKEL_ID VARCHAR(50) PRIMARY KEY NOT NULL,
    TEXT VARCHAR(50),
    time TIMESTAMP
    )
    Steps to reproduce
    
    Unzip in Windows with Visual Studio 2017 Pro
    Further technical details
    
    Version 4.7.670.0 - 1.576.065 downloads
    
    SQL Server Compact 4.0 in GAC - No
    SQL Server Compact 4.0 DbProvider - No
    
    SQL Server Compact 4.0 DDEX provider - No
    SQL Server Compact 4.0 Simple DDEX provider - Yes
    
    SQL Server Compact 3.5 in GAC - No
    SQL Server Compact 3.5 DbProvider - No
    
    SQL Server Compact 3.5 DDEX provider - No
    
    Sync Framework 2.1 SqlCe 3.5 provider - No
    
    SQLite ADO.NET Provider included: 1.0.112.0
    SQLite EF6 DbProvider in GAC - Yes
    System.Data.SQLite DDEX provider - No
    SQLite Simple DDEX provider - Yes
    
  3. login: "anonymous"
  4. mimetype: "text/x-markdown"
  5. private_contact changed to: "c36c8817d2c95ee6a655f854a08d77bbe858dbd0"
  6. severity changed to: "Important"
  7. status changed to: "Open"
  8. title changed to:
    The string was not recognized as a valid DateTime at timestamp
    
  9. type changed to: "Incident"