Truncate auto incremented column within a delete actionresult
===

Hi I am wondering if there is a way of using the truncate function within a delete actionresult. 

For example, a product with the id number of 7 it deleted from the table I want the next record below it to then have the id number of 7, therefore not having total different id numbers within the Products table, especially if more products get deleted.

Is there a way to do this within an asp.mvc actionResult??

Can someone please help me out with this. Many Thanks 