Our application will need to create queries that will eventually exceed available memory.
For this reason, we used the SelectLazy method. Recently I looked at the source and found that the database still pulls the entire result set but the results are enumerated using a yield.
I found that there is a technique called a Forward-only result set. While this code is java, that same calls should be available in c#
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
Is there anyway I can add this to my ormlite querys?
Is there a better way that you know of?
Thanks for the help.