Reg: Result set memory review

Question

Hello Team,

 

We have developed a WPF application which is using ADO.Net to read data from the SQL server. As part of my application executing a query that returns 20,00,000 records. At this time application is consuming more than 5 GB memory whereas if we run the query from Management Studio it takes less memory(i.e 40 MB). Since we are loading the same data from both applications, and SSMS. We want to know why the SSMS is taking very little memory when we compare it with the application.

 

Regards,

Chakradhar