Re: [sqlite] DateTimeOffset in SQLite
No solution? :( Joe can you help perhaps? You help me so much with my other problem with the Entity Framework. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DateTimeOffset in SQLite
Pavel wrotes: > > I don't know C#, but quick look at Microsoft's documentation shows that you > can get Ticks() from TimeSpan, save it into DB and then when you get Int64 > from DB you can create TimeSpan from it. > Seems not to work entity framework cannot convert "long" to the type "TimeSpan". I know I can make a "long" field and extend the entity class with a "TimeSpan" property that convert it. But I want to find a "entity framework way" to do this. Here the EDMX generator error: Member Mapping specified is not valid. The type 'Edm.DateTimeOffset[Nullable=False,DefaultValue=,Precision=]' of element 'Type ' of member 'TestProperty' in type 'TestEntity' is not compatible with 'Typ' of member 'SQLite.integer[Nullable=False,DefaultValue=]' in type 'TestEntity'. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DateTimeOffset in SQLite
On Wed, Oct 12, 2011 at 9:08 AM, Steffen Mangold wrote: > > Igor Tandetnik wrote: > >>What's DateTimeOffset? Offset from what to what? What exactly are you trying >>to achieve? >>See if this helps: http://www.sqlite.org/lang_datefunc.html > > In C# (.Net) it is the type Timespan. > I want to save a timespan in the DB and get an TimeSpan object in .Net out of > the DB. I don't know C#, but quick look at Microsoft's documentation shows that you can get Ticks() from TimeSpan, save it into DB and then when you get Int64 from DB you can create TimeSpan from it. Pavel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DateTimeOffset in SQLite
Igor Tandetnik wrote: >What's DateTimeOffset? Offset from what to what? What exactly are you trying >to achieve? >See if this helps: http://www.sqlite.org/lang_datefunc.html In C# (.Net) it is the type Timespan. I want to save a timespan in the DB and get an TimeSpan object in .Net out of the DB. -- Steffen Mangold ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DateTimeOffset in SQLite
Steffen Mangold wrote: > how to use DateTimeOffset with Sqlite, if it is possible? What's DateTimeOffset? Offset from what to what? What exactly are you trying to achieve? See if this helps: http://www.sqlite.org/lang_datefunc.html -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] DateTimeOffset in SQLite
Hi all, how to use DateTimeOffset with Sqlite, if it is possible? Regards Steffen Mangold ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users