Cache Provider

The name of the provider to be used to cache data.

Data Type

string

Default Value

""

Remarks

The component can cache data to a database when AutoCache is set. You can cache to any database that you have an ADO.NET provider for. The component has been tested with SQL Server, Derby, MySQL, Oracle, and SQLite.

The cache database is determined based on CacheProvider and the CacheConnection properties. The CacheProvider is the name of the DbProviderFactory used to cache data. You can find the provider factories available to you in your machine.config and add more providers in your app.config or web.config. The example below caches to SQL Server:

Cache Provider=MySql.Data.MySqlClient;Cache Connection='Server=localhost;Port=3306;Database=cache;Uid=root;Pwd=123456;'