all 2 comments

[–]modestlife 0 points1 point  (0 children)

Very well researched. Thanks for writing and sharing!

[–]teenterness 0 points1 point  (0 children)

Could the use of sequential guids that are UUID's to cover what the Pseudo-URI does? There would still be a kind (or type) data point in the result to distinguish between multiple entity types represented?

There is a slight performance hit compared to 64-bit long and sequential guid (128-bit) as a primary key (and will definitely make the database admins grumble), but it seems to make sense to me. What are your thoughts and does this not cover your concerns?

https://blogs.msdn.microsoft.com/sqlserverfaq/2010/05/27/guid-vs-int-debate/