Database cache (also known as connection cache, or cache) is a mechanism employed in PowerServer to store and manage the database connection information. It is responsible for maintaining the necessary details required to connect to the database server, including user ID, password, database connection string, and other essential information. PowerServer leverages the cache to establish connections with the database.
For each transaction object used in the application, a corresponding cache must be mapped with in order to to set up the database connection during runtime. This mapping can be accomplished through either the project painter in IDE or through application scripts.
The cache itself can be created and managed either within the project painter in IDE or through the PowerServer config file. Typically, it is created in the project painter as it is required during the project build process within the IDE. During this process, the IDE connects to the target database and generates PowerServer C# models. During the build process, the cache is also deployed to PowerServer and then used at runtime to establish connections with the database when the application is executed.
