Hi, I am having an out of memory issue reading large binary data from a table using NHibernate (the data is about 100mb). I found a helpful article about creating a custom user type to enable streaming of the data (http://blog.calyptus.eu/seb/2009/03/large-object-storage-for- nhibernate-and-ddd-part-1-blobs-clobs-and-xlobs/). I also found an article on how to do this directly in sql (http://msdn.microsoft.com/ en-us/library/87z0hy49(VS.80).aspx).
The problem is that if I do stream the data using the data reader passed to the custom user type I still get the out of memory error, because the data reader needs to be “executed” with SequentialAccess (as shown in the direct sql article) for data as large as mine. For example: SqlDataReader reader = command.ExecuteReader (CommandBehavior.SequentialAccess); Is there a way for NHibernate to pass a IDataReader that has been created with Sequential Access for my specific scenario? I’m not really sure where to go from here, so any help would be greatly appreciated. Cheers, -Matt. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
