Hi Andrew, First, depending on the amount of data to be transferred, NHibernate may not be the best choice for moving data from Oracle to SQLite.
As for your question about a memory stream, I don't think this is possible as you have envisioned it. However, I do know of a way to at least beef up the performance of getting a file db. In this blog post - http://jasondentler.com/blog/2009/09/nhibernate-testing-with-sqlite-in-memory-db/ - I have a SQLiteDataLoader class that I use to quickly transfer data from an attached file db to the memory db. What I imagine in this case is just the opposite. Write your data to the memory db, attach the file db to the memory db, and perform bulk inserts from the memory db to the file db. Then detach the file db and send it to the user. It still requires a file on disk, but it is *probably* faster than writing to a file db directly. Thanks, Jason On Mon, Apr 19, 2010 at 9:44 AM, annagel <[email protected]> wrote: > We are going to be using NHibernate as the interface between a WPF > application and a backing SQLite data store. The SQLite db files will > be created dynamically on a site our users can access do download a > particular file. The basic process I am envisioning at this point is: > > 1. Load out object model from the backing data system (in this case > an Oracle database) > 2. Save the object model via NHibernate to a temp SQLite file > 3. Serve this file back to the user > > Is there a way I can modify step 2 so that I only save the DB to > memory stream and then dump that stream back to user via the response > object? > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
