Page 1 of 1
Can I do the following with dotConnect for SQLite
Posted: Tue 26 Oct 2010 00:25
by PK
Hi folks,
can dotConnect for SQLite do the following against an Entity Framework V4 ?
1. Model First -> generate DB schema(s)
2. DateTimeOffset property type.
cheers
Posted: Tue 26 Oct 2010 15:42
by AndreyR
We are unable to add EDM Designer support in design time, so there is no Model First design time support.
We plan to add this functionality in Entity Developer, however.
As for the DateTimeOffset property type, what kind of support do you mean?
Posted: Tue 26 Oct 2010 22:55
by PK
AndreyR wrote:We are unable to add EDM Designer support in design time, so there is no Model First design time support.
Really? that hurts
AndreyR wrote:As for the DateTimeOffset property type, what kind of support do you mean?
Can I create a DateTimeOffset property on my POCO and have it save to a SQLite DB table with that DB field also being a DateTimeOffset property?
Posted: Thu 28 Oct 2010 14:51
by AndreyR
We will test the DateTimeOffset behaviour as soon as the Update To Database functionality is implemented.
Posted: Thu 24 Nov 2011 09:58
by Shalex
We have investigated the possibility of implementing the DateTimeOffset support. Unfortunately, there is no way to support DateTimeOffset completely. We recommend to store dates in the UTC format.