DBCC CHECKIDENT (MyTable, RESEED, NewValue)

您也可以执行截断表"，但是，当然，这也会从表中删除所有行.

You can also do a Truncate Table, but, of course, that will remove all rows from the table as well.

要通过L2S做到这一点:

To do this via L2S:

db.ExecuteCommand("DBCC CHECKIDENT('MyTable', RESEED, NewValue);");

或者，您可以从L2S调用存储过程来实现

Or, you can call a stored procedure, from L2S, to do it