Static database connection means the connection configuration (including connection cache settings, and transaction-to-cache mappings) is created before the app is run. The connection configuration is initially created in the Database Configuration window and gets deployed to the PowerServer C# solution. Although you may further update the connection configuration in the solution, the configuration from the solution will be used during the app runtime.