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

Postby 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: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby 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.
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby 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

Postby 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.
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

Postby 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.
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia


Return to LinqConnect (LINQ to SQL support)