I need to use Azure Price Sheet into my c# application to validate the meter Id, i am able to get response from the HTTPClient as success but due to the file size is too big (70MB +) i am unable to read using Stream or even cannot serialize it to list object. I am getting Out of memory error for anything i tried.
Below option i tried,
- Using DotNetZip to extract into Memory Stream, but while reading from Stream its throwing out of memory due to size of data
- Storing file into Blob storage and reading into C# code using MemoryStream, but its throwing out of memory due to size of data.
Any help would be appreciated.