I have used Stored Procedure For this : This method can be used to create a automatic id, and if id is deleted by user,then that id can be reused...
Create procedure [dbo].[Add_Articles]
@catid int,
@subid int,
@title varchar(200),
@desc varchar(max),
@tags varchar(50),
@dop date,
@userid varchar(100),
@active bit
as
begin
Declare @Id int
Select @id=ISNULL(Max(ArticleID),0) from ArticleTB
Set @Id = @Id +1
Insert into ArticleTB(ArticleID,CategoryID,SubcategoryID,Title,Description,Tags,DOP,UserID,IsActive)values(@Id,@catid,@subid,@title,@desc,@tags,@dop,@userid,@active)
select 1
end