Oct 21, 2019 06:41 AM|Yang Shen|LINK
Does the code work for the xml structure if it is different than what you have posted?
It should work and you can just test it. You can also refer to select top 5 records from xml with C# for more information about using Linq to get items
from xml document.
But for your xml file, it seems a little confusing that which 50 rows you mean you want to fecth, this method will work for items but not sure what about the rows.
As far as i know, these methods are based on nodes instead of rows, maybe you could provide a more detailed description.