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 (read more) or through application scripts (read more).
The cache itself can be created and managed either within the project painter in IDE (read more) or through the PowerServer config file (read more). 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 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.
