Hi - Using VS Studio 2005 - VB.Net and MS SQL Server 2005 Compact on
the desktop

I am in the process of writing some code that follows this pattern:

1) Cycle through all database files in all project directories - could
be 1000's of project files all containing 2 databases or more. Each
will need to be accessed using a unique connection string that is
programmatically generated.

2) Test schema to see if all tables and columns are present according
to meta data

3) If schema passes test, then check to see if there is at least one
record present.

4) If schema does not pass or passes but tables have no data then the
whole project directory (folders and sub folders are deleted)

All files will be open, closed, then disposed. I have already tested
this on a directory of 50 or so files using a RAM monitor and can not
see any system degradation.

It is important that I do this right. Even with Try - Catch - Do you
see any problems with the opening and closing of 1000's of connections
in one process? No new one will be opened until the current one has
been processed then closed and disposed.

Thanks

The Mad Ape
www.tatumba.com