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.
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. |