ADO.NET API for Database Samples

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 2013 or later and Linux samples require a standard Linux development environment.

Database examples

Downloadable Database Samples for Windows

C/C++ C# Description
Hello World Hello World Hello World. Create & initialize database if not present. Create one record, read and print all records.
SQL02 SQL02 Primary/Foreign-key reference. Two table types, second referencing the first.
SQL03 SQL03 Hierarchy. Same as SQL02 but with three tables.
SQL04 SQL04 Indexing. Create 10 rows with random values in indexed column. Select all in order and print.
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 Multiple databases. Create, initialize and populate two databases. Open one, then the other. Demonstrate usage of both at once.
SQL07 SQL07 SQL Parameters. Show how ADO.NET uses parameters, contrasted to ODBC and JDBC.
SQL08 SQL08 Transaction. Insert rows in a transaction. Commit then select and print them.
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 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 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 TFServer. Spawn TFServer. Then create same threads as SQL11, but configured for RPC to the separate process.
SQL13 SQL13 Multi-process. Same as SQL12 except that processes are spawned, not threads.
SQL14 SQL14 Read-only-transactions. Same as SQL13 except that the reader processes use MVCC (Multi-Version-Concurrency-Control) ROTs rather than locks.