Devart Forums

Posted: **Mon 18 Feb 2013 06:29**

Hello,

LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012.

1) Have Class "TestClass";
2) Include field "TestId" with property:

Auto-sync: OnInsert
Entity Key: True
IdGenerator: Identity
Name:TestId
ReadOnly: True
Source: TestId
Type: System.Int32

3) Generate this script:

Code: Select all

-- Script was generated by Devart Entity Developer, Version 5.0.43.0
-- Script date 18.02.2013 10:25:47
-- Target Server: SQL Server
-- Server Version: 2012

-- 
-- Creating a table dbo.TestClass 
-- 
CREATE TABLE dbo.TestClass (
   TestId INT NOT NULL,
   Name VARCHAR(MAX) NOT NULL,
   CONSTRAINT PK_TestClass PRIMARY KEY (TestId)
)
GO

but must be like this:

Code: Select all

TestId INT NOT NULL IDENTITY(1,1),

Very much I ask fix it as soon as possible.
This causes big problems.

Thanks.

Posted: **Mon 18 Feb 2013 06:53**

I need to use the one model to generate and update the database for MySQL, Oracle, Posgre SQL, SQLite and SQL Server!
How do I do with the auto-increment fields?

Now with MySQL, Oracle, SQLite auto-increment columns are correct, and for SQL Server not.

Originally the property, IdGenerator = (None), and for MySQL, Oracle, SQLite everything was normal, but with SQL Server not. I tried to make IdGenerator = Identity, but it did not help.

How to do it?
Or there is an error in the component?
Or am I doing something wrong?

Please help me.

Posted: **Mon 18 Feb 2013 10:08**

Thank you for the report. We have reproduced the issue with auto-increment fields for SQL Server and we will inform you when it is fixed.

Posted: **Tue 19 Feb 2013 11:15**

The bug related to the wrong script generating for identity columns in SQL Server has been fixed. The fix will be included in the next build of LinqConnect, which we plan to release this week. We will inform you when it is available for download.

Posted: **Mon 04 Mar 2013 05:35**

Update to LinqConnect Professional Version 4.1.197 (28-Feb-2013) and test!
All work nice.
Thanks.

PS: Edit post.

Devart Forums

LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012

LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012

Re: LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012

Re: LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012

Re: LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012

Re: LinqConnect Professional Version 4.1.184 (07-Feb-2013) - don`t create IDENTITY for SQL Server 2012