Search code examples
c#databasenhibernatestreamresultset

NHibernate - Stream large result sets?

I have to read in a large record set, process it, then write it out to a flat file.

The large result set comes from a Stored Proc in SQL 2000.

I currently have:
var results = session.CreateSQLQuery("exec usp_SalesExtract").List();

I would like to be able to read the result set row by row, to reduce the memory foot print

Thanks

Solution

  • NHibernate is not designed for that usage. Plus, you're not really using its features.

    So, in this case, it's better to use raw ADO.NET.