ScimoreDB Embedded database has been implemented in a single DLL file (scimoredb.dll). The database can be either loaded into client’s application process for a single access or started as a separate process to allow share the database between multiple applications. 

To Create/Open embedded database, use: C++ scdriver.lib/scdriver.dll - CEmbeddedDB or .NET Data Provider - ScimoreEmbedded classes. First, embedded database needs to be created on disk. The Create(database folder) method will store system tables and transaction log under the folder. Now, call Open(database folder) . Depending of the specified startup DB parameters, the database will be loaded into the client’s process as DLL or on-demand started as separate process (rundll32) for the shared access. If shared database has been already started by other client, e.g. ScimoreDB manager, new rundll32 will not be started. When all clients exits, rundll32 process will close as well. 

Hosted embedded database communicates with a client application using: direct memory access if scimoredb.dll loaded in-process or shared memory protocol, if database started as separate process (scimoredb.dll loaded by rundll32). 

Check out get-started page: http://www.scimore.com/products/tutorial/Embedded-Get-Started-in-3-minutes/ 

Database startup settings 

.NET provider’s ScimoreEmbedded class has 3 properties, which allow setting embedded DB startup parameters: 

• MaxConnections – Maximum number of concurrent connections. Default – 8. 

• MemoryPages – Number of DB pages (each takes 8KB) cached in memory. Default – 3000. We recommend do not set below it. 

• MaxLocks – Maximum number of exclusive locks. Update/Delete command for each affected row requires the lock and holds it until transaction committed. Default – 65539. If you delete/update large data set, you will need to increase number of locks. 

Samples 

• Filer – using from c++ application 

• VB – Sample1 and Sample2 for VB.NET, Sample3 (VB6, requires to register sccomdriver.dll COM object available at : http://www.scimore.com/download/2.5/ ) 

• C# – Sample