In Memory SQLite Capability
In Memory SQLite Capability
Does the new SQLite provider have the capability of supporting an in-memory db? We have the requirement to load an encrypted SQLite db file directly into a memory db. We have written routines to encrypt the file and to decrypt the file directly to a stream but we need the ability to load that stream into the database component.
SQLite supports in-memory database (you should assing ':memory:' to the Database property). But this is a temporary empty database. You can create tables in it after connecting. This database is deleted after disconnecting.
SQLite does not support connecting to an existing in-memory database. You can save your database to a file, and then connect to the file.
SQLite does not support connecting to an existing in-memory database. You can save your database to a file, and then connect to the file.