ADO.NET API for Visual Basic Popcorn Samples

Back to Home Page »

What is a Popcorn Sample?

It’s a taste of the real thing. These are fully contained, downloadable, ADO.NET API for Visual Basic samples of our product and each download highlights a certain feature within RDM. We call these Popcorn samples, just as you would take a product sample in a store.
Duration = 5 minutes or less.

Downloadable Popcorn Samples

Windows 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 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 Multi-user. Create a new database. Spawn multiple writer threads that insert rows in transactions. Spawn multiple reader threads that use read locks.
SQL12 TFServer. Spawn TFServer. Then create same threads as SQL11, but configured for RPC to the separate process.
SQL13 Multi-process. Same as SQL12 except that processes are spawned, not threads.
SQL14 Read-only-transactions. Same as SQL13 except that the reader processes use MVCC (Multi-Version-Concurrency-Control) ROTs rather than locks.


Hello World Popcorn Samples: Wayne Warren, CTO, explains what these are.

Instructions

  1. Download the sample.
  2. Build it – it’s all set up.
  3. Run it in your debugger & watch.
  4. "Oh, That’s easy!"
  5. Delete it
Hello World Home
Performance Popcorn Samples

Note: Windows samples require Visual Studio 2008 or 2010 and Linux samples require a standard Linux development environment.

Full Product Download

Infographics