Lee Reiber wrote: > > Is there a way on connection to use a flag to GetAllAsTextIfDateTime ? >
The following might be able to help: SQLiteConnection connection = new SQLiteConnection( "Data Source=C:\\some\\path\\test.db;Flags=UseConnectionTypes;"); connection.AddTypeMapping("DATETIME", DbType.String, true); Please note that you may need to add more mappings if the DateTime type names you need are not always "DATETIME". Also, please let us know if this works for you. -- Joe Mistachkin