Auto Increment In azure Mobile Services

Question

Dear Sir/Madam I want to do auto increment in azure mobile services table.But i did not have clear idea about that.Can you give me the Solution for that.i am waiting for your positive response... Thank you...

Prakash Tripathi · Answer

Tables in AMS tables are regular SQL Azure table. (AMS is just a wrapper on top of SQL Azure). Did you try using IDENTITY column as below? CREATE TABLE [dbo].[crmProducts]( [PId] [int] IDENTITY (11) NOT NULL [crmProdid] [varchar](1000) NULL [ProductName] [varchar](255) NULL [ProductNumber] [varchar](255) NULL )