Devart Forums

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

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

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

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.

Hi Shalex,

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

Regards,
Shaun

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 .