but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy, we'd just run: ...

For these example applications, the classes assume a SQL Server database included in the article download. To better structure the code samples, I placed each application in its own separate directory ...