title: Memory Stream as DB
body: <p>I'm currently thinking of using <code>SQLite</code> as db engine for my C# project, but i ran into the following problem: i can't find any API for memory storage. What i want to achieve is the following:</p>
  
  <p>Upon start of the program i want to load the db file (from HDD) into memory.
  During execution of the program i want to use this memory stream as a real db (read,write,insert,select etc).
  Upon closing save the stream to the file.</p>
  
  <p>Can anyone point me in the right way or suggest another db engine that would be better suited for this purpose.</p>