This is a really a great experience for me, because I got an opportunities to work for mid level Asp.Net web application, actually it’s remodeling of winFrom application to standard Asp.Net 3.5 web application where I worked with almost 50 tables and I found that all the tables using
Guid()/ NweId() ( return 36 digit alphanumeric character) for PK and FK key mapping. I discussed with my team lead about this issues, because I want the data paging must be server side and data shorting will be client side where I must concern on the application performance, each table contain more than 10 thousand of rows. So finally discover that a single SQL function could resolve these issues.
SELECT ROW_NUMBER() OVER(ORDER BY [col_1]) as RowNumber, * FROM [Example].[dbo].[Table_A]