I'm trying to create a database then a table then insert a few rows
into the new table.

All of that works, but if I try to delete the database file
afterwards, the file is in use by another process, how should I
effectively close out all activity so that the file can be deleted?

Here is my process:

Create database
Create connection
Create transaction
Create command
Run SQL
Commit transaction
Close connection
Dispose transaction
Dispose command
Dispose connection