Can i fetch "in pieces of 100" big sized data with DataReader RRS feed

  • General discussion

  • Hi,

    I would like to get data slowly. For example I have some database views which have 10 million records. I wouldn't like to whole data at first time when I read a view. Because i think that if data is so big, i can get Out of Memory Exception in some cases. I don't know the size or record count of data. Only i would like to fetch data fragmentally. These parts may be set of 100 or 1000. I have to decided part sizes.

    In Java programming language, Hibernate framework do that with ScrollableResult class. Is there any method to do that in .Net?


    Friday, September 23, 2016 10:52 AM