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