How to have two auto increment columns in sql - entity framework mapping

Question

My sql table has two columns that needs identity generated.

1) ID //its identity seeds trwo, identity(1,1)

2) pGuid //newid() as default values

Problem is when insert entry from UI then, it works for ID and not for pGuid field.

using entity framework, fluent API.

mapping added as

'this.property("pGuid").HasColumn("pGuid");`

what is missing with mapping and so, its not working.

Duplicate even though your column isn't a primary key. – Gert Arnold Dec 20 '17 at 20:25 — Gert Arnold, Dec 20 '17 at 20:25

score 0 · Answer 1 · answered Dec 20 '17 at 20:05

You can create the table with pGuid column as 'uniqueidentifier' datatype with default value as newid() as shown below, then if you insert value using EF to other columns (e.g. Company) in below table, identity and newid() values will be automatically inserted in the new row for ID and pGuid columns.

CREATE TABLE MyTable  
(  
ID INT IDENTITY(1,1) PRIMARY KEY,
 pGuid uniqueidentifier NOT NULL DEFAULT newid(),  
 Company varchar(30) NOT NULL,
..........
)

How to have two auto increment columns in sql - entity framework mapping

1 Answers1