c# tableadapter - get identity on insert - SQL Server CE

• a.ambron

  SSC Enthusiast

  Points: 119

  More actions

  March 21, 2011 at 6:03 pm

  #233512

  Hi All

  I'm trying to get the identity of an inserted record from a table in SQL Server CE using a table adapter , but not able to. I tested the same in SQL Server - no problem. Can anyone help? I'm programming in C#.

  Thanks!

• prem.niet

  Valued Member

  Points: 69

  More actions

  April 27, 2011 at 5:28 am

  #1316478

  Hi.. i think for that You need to use

  SCOPE_IDENTITY()

  @@IDENTITY in sql server 2005.