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..