Re: [sqlite] System.Data.SQLite.EF6 feature request: Timespan support

2019-08-19 Thread Joe Mistachkin
I’ll look into adding this type mapping to System.Data.SQLite. Sent from my iPhone > On Aug 19, 2019, at 7:19 PM, Barry wrote: > > A project I work on runs mainly on SQL Server, but there are times we want > to be able to create the same data model in SQLite for portability. > > We mostly use

Re: [sqlite] System.Data.SQLite.EF6 feature request: Timespan support

2019-08-19 Thread Barry
Hi Simon, The System.Data.SQLite (basically a dotNet wrapper for SQLite, and official part of SQLite) team maintain a library called System.Data.SQLite.EF6, which I understand to be the glue between the Entity Framework and SQLite. If my understanding is correct, this is the library that should be

Re: [sqlite] System.Data.SQLite.EF6 feature request: Timespan support

2019-08-19 Thread Simon Slavin
On 20 Aug 2019, at 12:19am, Barry wrote: > Would it be possible for a future version of SQLite to support TimeSpan > mapping in the entity framework? This is not an aspect of SQLite itself, but of how Entity Framework 6 talks to SQLite. The development team who could affect this change are th

[sqlite] System.Data.SQLite.EF6 feature request: Timespan support

2019-08-19 Thread Barry
A project I work on runs mainly on SQL Server, but there are times we want to be able to create the same data model in SQLite for portability. We mostly use EF6 to access the database; we have a code-first approach and write custom scripts to generate the database schema. We have a custom Connect