Can I do the following with dotConnect for SQLite

PK · Post by PK » Tue 26 Oct 2010 00:25

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

AndreyR · Post by **AndreyR** » Tue 26 Oct 2010 15:42

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?

PK · Post by PK » Tue 26 Oct 2010 22:55

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?

AndreyR · Post by **AndreyR** » Thu 28 Oct 2010 14:51

We will test the DateTimeOffset behaviour as soon as the Update To Database functionality is implemented.

Shalex · Post by **Shalex** » Thu 24 Nov 2011 09:58

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.