I'm using v4.2 (Nov 20th 2015). Sql 2014.
On the "Relational Model Data" I have the text (changes pending).
The generated ddl sql update script has 4 similar table ddl snippets for 4 different tables:
ALTER TABLE [dbo].[Language]
-- Identity constraint was changed on field 'LanguageId'. However SQL Server doesn't allow changing this in SQL.
-- This means that you have to do this manually by creating a new temporary column, copy over all data and then remove
-- the column (cumbersome, due to FK constraints). Another, probably less cumbersome way, is to do this through SSMS, which
-- does the handling for you. Example of how to do it manually:
-- http://stackoverflow.com/questions/702745/sql-server-how-to-drop-identity-from-a-column
-- Discussion about this issue on MS' forums:
-- http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/04d69ee6-d4f5-4f8f-a115-d89f7bcbc032/
ALTER COLUMN [LanguageId] [int] IDENTITY (1,1) NOT NULL
GO
When I first generated code all 4 tables had the identity property set to Yes. However, since then the identity property has been changed to No (would like to keep it this way).
I have tried to remove and re-add the tables, which does not change the state.
Are the changed settings not picked up by the designer?
/Morten