In your table(Sql Table), truncate your all data (If required keep a backup). Now, alter your column
CustomerId
and set it as
IDENTITY
. After that you don't suppose to insert the value in identity column.
Try this:
alter table table1 add col3 int identity(1,1)
Refer
this[
^] for more information on identity columns.
--Amit