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