ADO.NET API for Visual Basic Popcorn Samples
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
|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.
- Download the sample.
- Build it – it’s all set up.
- Run it in your debugger & watch.
- "Oh, That’s easy!"
- Delete it
Performance Popcorn Samples
Note: Windows samples require Visual Studio 2008 or 2010 and Linux samples require a standard Linux development environment.
Full Product Download