How To Generate Record Row Number In Linq to Sql.

Question

Hey frnds 

 

i want to generate a Sr. No. in grid of all The Records using  linq to sql query..

i have done this thing in Sql Query but i want to do it with linq..

 

select

ROW_NUMBER() Over (Order by SID) As [S.N.], [ProductBrand],[ProductModel]

[Type]

from stock where stockStatus='YES'

please make the linq query of above query..