Contact Sales What is a Database Sample?
It’s a taste of the real thing. These are fully contained, downloadable database functionality samples of our Raima Database Manager (RDM) , and each download highlights a certain feature within RDM. Click on the Database Samples links to view the complete series for each API. Duration = 5 minutes or less.
Note: Windows samples require Visual Studio 2008 or 2010 and Linux samples require a standard Linux development environment.
Instructions
- Download the sample.
- Build it – it’s all set up.
- Run it in your debugger & watch.
- “Oh, That’s easy!”
- Try the next one
Downloadable Database Samples for Windows
| C/C++ | C# | F# | VB | Description |
|---|---|---|---|---|
| Hello World | Hello World | Hello World | Hello World | Hello World. Create & initialize database if not present. Create one record, read and print all records. |
| SQL02 | SQL02 | SQL02 | SQL02 | Primary/Foreign-key reference. Two table types, second referencing the first. |
| SQL03 | SQL03 | SQL03 | SQL03 | Hierarchy. Same as SQL02 but with three tables. |
| SQL04 | SQL04 | SQL04 | SQL04 | Indexing. Create 10 rows with random values in indexed column. Select all in order and print. |
| SQL05 | SQL05 | SQL05 | SQL05 | Many-to-many. Three tables, two foreign key references constructing a many-to-many relationship. Populate with a few rows. Select and print from one side, then from the other. |
| SQL06 | SQL06 | SQL06 | SQL06 | Multiple databases. Create, initialize and populate two databases. Open one, then the other. Demonstrate usage of both at once. |
| SQL07 | SQL07 | SQL07 | SQL07 | SQL Parameters. Show how ADO.NET uses parameters, contrasted to ODBC and JDBC. |
| SQL08 | SQL08 | SQL08 | SQL08 | Transaction. Insert rows in a transaction. Commit then select and print them. |
| SQL09 | SQL09 | SQL09 | SQL09 | Transaction abort. Insert and commit some rows. Insert more rows, but abort the transaction. Select all rows and see only the first set of rows. |
| SQL10 | SQL10 | SQL10 | SQL10 | Shared mode. No longer exclusive (“x”) mode. Create two connections. First connection populates database and holds transaction. Second connection attempts to read but times out. |
| SQL11 | SQL11 | SQL11 | SQL11 | Multi-user. Create a new database. Spawn multiple writer threads that insert rows in transactions. Spawn multiple reader threads that use read locks. |
| SQL12 | SQL12 | SQL12 | SQL12 | TFServer. Spawn TFServer. Then create same threads as SQL11, but configured for RPC to the separate process. |
| SQL13 | SQL13 | SQL13 | SQL13 | Multi-process. Same as SQL12 except that processes are spawned, not threads. |
| SQL14 | SQL14 | SQL14 | SQL14 | Read-only-transactions. Same as SQL13 except that the reader processes use MVCC (Multi-Version-Concurrency-Control) ROTs rather than locks. |
