c# sql recount after deletion code example

Example: sql server reset auto increment

DBCC CHECKIDENT (mytable, RESEED, 0)