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 project painter > Database page and gets deployed to the PowerServer C# solution. Although you may further update the connection configuration in the PowerServer, the configuration from the PowerServer will be used during the app runtime.