none
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?

    Thx

    Friday, September 23, 2016 10:52 AM