Open GoogleCodeExporter opened 9 years ago
Hello,
Does that table you are generating against have a primary key? If so, is this
primary key an identity column?
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 5 Oct 2010 at 10:41
Yes,
this column is primary key and identity column
Thanks
Adiel
Original comment by adiel.sh...@gmail.com
on 5 Oct 2010 at 11:00
Hello,
I have not been able to reproduce this with a table schema as defined below:
<Column Name="testID" Member="testID" Storage="_testID" Type="System.Int32"
DbType="int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true"
CanBeNull="false" />
Could you please attach a sql script that will recreate your database table
that I can test PLINQO against.
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 19 Nov 2010 at 8:51
Hi
this is the create script:
USE [DBName]
GO
/****** Object: Table [dbo].[Devices] Script Date: 11/21/2010 13:53:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Devices](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[DeviceType] [nvarchar](50) NOT NULL,
[DeviceID] [nvarchar](50) NOT NULL,
[StoredSignature] [image] NULL,
[IsEnrolled] [bit] NOT NULL,
[SecurityLevel] [int] NULL,
[PassCounter] [int] NULL,
[FailCounter] [int] NULL,
[PushToken] [nvarchar](100) NULL,
CONSTRAINT [PK_Devices] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Thanks
Adiel
Original comment by adiel.sh...@gmail.com
on 21 Nov 2010 at 11:55
Hello,
I have been able to reproduce this issue and we will get this fixed. If you add
the IsDbGenerated="true" attribute than it will be preserved across
regeneration. But we currently don't update this attribute if it is added or
removed to the database column.
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 23 Nov 2010 at 10:42
Hi
In my experience I have to add this attribute in every regeneration.
Let me know when it will be fixed.
Thanks again
Adiel
Original comment by hila...@gmail.com
on 24 Nov 2010 at 1:55
Hello,
If you are using the latest version of PLINQO and the latest version of
CodeSmith Generator 5.3.1 and you have to add in the attribute every time.
Could you please attach a two minute screen cast of this happening. I found
this tool to be the best free screen cast utility
(http://www.techsmith.com/jing/)
Please let me know if you have any questions.
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 29 Nov 2010 at 7:24
Hi
I've download the last PLINQO and CodeSmith.
The video attached.
Thanks
Original comment by adiel.sh...@gmail.com
on 29 Nov 2010 at 3:59
Attachments:
Hello,
Sorry for the late response. The attribute must be set in the DBML File in
order to be preserved.
Example: <Column Name="CartId" Storage="_cartId" Type="System.Int32"
DbType="int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true"
CanBeNull="false" />
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 8 Dec 2010 at 11:13
Many Thanks!!!!
Original comment by adiel.sh...@gmail.com
on 12 Dec 2010 at 4:13
Original issue reported on code.google.com by
adiel.sh...@gmail.com
on 4 Oct 2010 at 1:51