linq autoid

How about this

Generate a number which equals to clock ticks. The ticks will be always unique.This will gurantee you generate an auto Id every time, though not starting at 1.

Now the issue is when you scale out and have multiple servers what do you do?
In such a case you should assign each server a number between 1000 and 9999 and prepend it to your tick

Now what if one each server you have multiple app's
In this case assign a similar number to each app and prepend it between server id and tick

So the auto gen number will be ServerId AppId Tick

A point to Dave. Linq may be used against an OO DB and not always a RDBMS.

Further ANSI standards say that you cant have identity mantained by DB.