Identity

Question

How to retrieve identity values from sqlserver using linq to sql.
example i have a table
empid, ename.
i want to insert new record
it should automatically empid should increment and it should be updated to database.

Satish Bhat · Answer

If properly mapped the Identity (key) is returned/populated in the key field of the entity/object when it is inserted into the database (after the .Savechanges()) In your case empid will be automatically populated in the object. Below are some useful links for your reference. Link 1 Link 2 Link 3

Prabhu Raja · Answer

hi Sreekanth you can identity value from table using SCOPE_IDENTITY() function. For example: Insert into emp (empname) values('xyz'); Select * from emp WHERE empid = SCOPE_IDENTITY(); Before using Identity's make sure that you set empid as identity ON . you can set identity's to columns by using Column Properties. you can find it at bottom of the table design page. click Identity Specification header and set (Is Identity) property from no to yes. ---------------------------------------------------------------- is this post helps you then click This is Correct Answer check box