Newbie question

Question

User1522642195 posted
Hi all, Iv just taken this fresh out of the box and noticed something that i cant find documentation on. In DDS's when I click insert, it asks for the primary key, -How can I ensure that the Primary key is auto generated by the DB and remove this UI option from the user? Any resources would be greatly appreciated :) #L

Answer 1

User-330204900 posted

First of all welcome [:D] to the wonderful world of DD

If you are using Linq to SQL that is the Dynamic Data Website or Dynamic Data Web Application Project the Entity Framwork stuff has Entity Framewrok in the name [:D], then its easy you just select the column in the Designe view, and in the Column Properties expand Identity Specification and set the (Is Identity) to Yes and your done.

From Blogger Pictures

 

the Entity Framwork is the same in SQL but the column will show in the Details, Edit, Insert and List pages you will have to use metadata to hide the column with [ScaffoldColumn(false)]

Hope this helps [:D]

Answer 2

User1522642195 posted
many thanks :)