SQLite and EF Store Generated Pattern Problem

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ShaunHarvey
Posts: 3
Joined: Thu 08 Sep 2011 08:02

SQLite and EF Store Generated Pattern Problem

Post by ShaunHarvey » Thu 08 Sep 2011 08:35

Hi,

I am new to the SQLite EF provider so this may be simple to answer!

I am generating a model from an existing SQLite database.

For the primary keys on the tables, the wizard is setting the Store Generated Pattern = "Identity".

However, I would like the default value to be "None" instead as we have a separate function within the application code that sets the primary key values for us.

Is it possible to change this default somewhere?

At the moment, each time we recreate/update the model from the Database these values are being overwriten to "Identity" again.

Regards,
Shaun Harvey

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 13 Sep 2011 13:37

This is a designed behaviour for SQLite at the moment. We are investigating the issue, and will post here about the results.

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 16 Sep 2011 11:22

We will implement Store Generated Pattern="None" as a default behaviour and notify you when it is done.

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 27 Oct 2011 16:47

The option to set Store Generated Pattern to None for int primary keys will be added starting from the next version (not build) of Entity Developer. We will post here when it is released.

ShaunHarvey
Posts: 3
Joined: Thu 08 Sep 2011 08:02

Post by ShaunHarvey » Thu 03 Nov 2011 09:38

Hi Shalex,

Thanks for looking into this. That will be a great help for us in the future.

Regards,
Shaun

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 09 Dec 2011 16:50

New version of Entity Developer 4.2 is released!
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22845 .

Post Reply