How To Generate Record Row Number In Linq to Sql.

Hi You can try this
var query = from s in stock
                    where s.stockStatus=="YES"
                    select new
                    {
                        ProductBrand = s.ProductBrand,
                        ProductModel = s.ProductModel,
                        Type=s.Type
                    };
                   
                     return query.AsEnumerable() // Client-side from here on
                    .Select((stock, index) => new stock()
                            {
                                ProductBrand = s.ProductBrand,
                        ProductModel = s.ProductModel,
                        Type=s.Type,
                                RowNumber = index + 1;
                            }
                    .ToList();