SQLite and EF Store Generated Pattern Problem

ShaunHarvey · 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 · 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 · 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 · 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 · 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 · 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 .