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

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » 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.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » 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.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Post by MariiaI » 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.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Post by MariiaI » 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.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » 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.

Post Reply